This content has been marked as final. Show 6 replies
can anyone throw some light?
Hello Experts, any idea?
It is quite difficult to explain every step(RPD,Analysis/Dashboards) on the forum
Please find the
U can start off with this for now.
Let us know if your facing any issues.
Thanks. I would need only ONE Clarification.
the Fact table has data at Date Level. For Example,
Date Revenue Stage
20120101 123.98 1a
20120302 178.965 1b
20120401 768.99 1c
The report should contain the following columns based on date range selection:- Start Date & End Date
Start_Date_Revenue End_Date_Revenue Start_Date_Stage End_Date_Stage
So, I have used FILTER(Revenue using Date = 'Presentation Variable for Start Date') & FILTER(Revenue using Date = 'Presentation Variable for End Date') for Revenue Calculation.
Similarly, is there any way to retrieve the stage columns data for each date and show it in report?
Note:_ I have tried the filter function for Dimension Column to bring Stage but it works only for Measure Column
Your issue is kind of Vague.Please try to put in a clear way.
*" I have tried the filter function for Dimension Column to bring Stage but it works only for Measure Column"*
Not sure what you are trying to achieve!!
I have explained it with example at low level. I don't know why you don't understand it. anyway, I have fixed it with the help of experts who understood the issue.