i have an issue with data while calculating the percentage.
the below two pivot table should show the same % value but, the second table is showing slighlty different data than the firat one. the correct data is the one in the first table. the expression used in both the table are given below. . i have several Rooms, but for example i have given only 2 Rooms.
Pivot Tbale1, in this Room is a dimension and Minute is Expression. and used Pivot option.
Minutes
Room1
0
15.75%
1-15
18.04%
16-30
15.30%
expression is =count(cases)/count(TOTAL Case)
this table should show the % based on the selction on Minutes, it should give the % of count in that particular Room. Minutes and Room is dimension and used one expression given below , then pivoted.
Minutes
Room1
0
16.20%
1-15
18.54%
16-30
15.73%
count(cases)/count(TOTAL<Room> Case)
please help... I am not able to find the cause of this difference in data.
Can you share sample file, so that it would be easier to analyse.
I think you need to use the Room dimension then only it will split accordingly. Since you are using same dimension in both the charts but different expression, I think you will get different results.
thanks for your reply. but sorry i am uanbel to share a sample app due different reasons.
ultimately both the expression shopulf give the same result. i need data to be represented like table 2. but for testing i created the table1. then only i found the difference.
What i need is on clicking 0 , the % of the count(cases ) for each and every Room should be diaplayed horizontally.
