Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have three dimensions
DATE, PHASE , GENERATION
01/01/2014 Delhi 10000
01/01/2014 Newyork 500
01/01/2014 Banglore 6000
.
.
.
.
.
17/11/2014 Delhi 3000
17/11/2014 newyork 9000
17/11/2014 Banglore 3000
NOW I WANT TO know on which date my generation was maximum for a particular phase ..
please help
Works for me, and in Excel max values are green, check to supress null values?
Check in attachment if this is what you want.
Hi navneet, please check attachment.
There is one table with GENERATION as expression and other as dimension, formula to background color is the same.
hey rubeen,
Your answer is helpful but i dont want any other dates
in a table i want first phase,
second date of max generation of that phase
third generation
Output:
Phase Date Generation
Delhi 01/01/2014 10000
Newyork 17/11/2014 9000
Banglore 01/01/2014 6000
Thats it!!!
Please help
from the example provided by Ruben, change the expression in the in the first chart to If(GENERATION=Aggr(NODISTINCT Max(GENERATION), PHASE),GENERATION)
and modify the sort tab if you want them in a specific order.
Ok, something like this attachment?
i TRIED ON MINE BUT ITS NOT WORKING .... I AM ATTACHING A DUMP
Thanks and regrds
Works for me, and in Excel max values are green, check to supress null values?
Check in attachment if this is what you want.
Thank you so much