Visualization - First and Last options in Values drop down

[gunjan80]

I have the below table. If I select a matrix in the visualization pane, by adding Customer in Rows and Products in Values and in Values drop down,  I select "First" then what will be the result? Which product will be shown in the table against each customer?

Customers	Products
Customer1	Product 1
Customer1	Product 2
Customer1	Product 3
Customer2	Product 2
Customer2	Product 3
Customer2	Product 3

[amitchandak]

@gunjan80 , first for that combination. what is the issue you are facing here

[gunjan80]

I'm looking at a report prepared by someone else. And they have used this table. I'm trying to figure out on what basis which product is selected and displayed against each customer.

[az38]

@gunjan80 

I haven't seen any documentation, but I pretty sure that using first value from unknown dataset is like lottery

[gunjan80]

Yes you are right. I tried it on a dummy table and it picks things randomly. Thanks for your help!

[az38]

Hi @gunjan80 

it will be almost random value, my opinion. 

I think there is some algorithm based on what exactly row is higher in data source, but I use this option if I have completely the same first and last text values in aggregated column