Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am looking for a way to display distinct values in a expression for a particular dimension.
Can we do this?
I have records like
Country State City
INDIA AP Hyderabad
INDIA MH Mumbai
USA CA San Fransisco
UK HS London
I want to display this in a table but India should not repeat....it should show blank like a pivot but i want to use table only..
Please help me.
Regards,
PK
Add a new Measure to the Sense straight table. Use this formula:
=IF(ABOVE(Country,1)=Country,NULL(),Country)
The Above() function, with an offset of 1 checks the row above to see if it is identical to the current row.
If you like this, please click 'Correct Answer'.
Regards,
John