Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Good Evening !!!
I am developing a comparative report which will show the comparison between to two months. Will it be possible to show , Drill down report to show the data difference between two months?
Example –
Month 1 has Values = 1,2,3
Month 2 has Values = 1,2,3,4,5
In output – I need to show the 4,5 in Straight table/Table box.
Can someone please guide me on this? For your information, I am able to show KPI numbers (Month 1 Total = 3 & Month 2 Total = 5) but unable to show drill down details?
Did ample amount of research but it seems the way I am trying to do is not possible.
This make sense, But the only thing i would ask you to build the same in Data model rather Front-End.. And, So when we opened thread using Drill Down that means you need to allocate P() and E() are in place.
Thanks Anil for response. Can you please give me some example of P() & E() i.e. how in this case i can able to use it?
Also I am using alternate states to compare data between two sets. Output currently I am getting is all the results from SET1 where as i want to show only the difference in straight table. Is it possible to do it?
Expression I used in this case -
=SUM({(SET1 - SET2)} SALES)
Please fill that expression? What are the Set1 and SEt2??
SET1 & SET 2 are alternate states which are assigned to two different selections.
Did ample amount of research but it seems the way I am trying to do is not possible.