How to display Total Values in Pivot irrelevant of Dimension
Hi All,
I have a following Query ...
I have a dimension named Occupancy . Occupancy consists of following values Subject1 , Subject2 , Subject3 ,Subject4 .
The total count of students for Subject1 + Subject2 +Subject3 + Subject4 =100.
But in the dimension I have to consider only subject1 and Subject2 as shown in the below table
In the Pivot Table I have to display the results as below
Year
Occupancy
Count of Students
Total Students
%
2010
Subject 1
30
100
30%
Subject 2
40
100
40%
The problem here is as I am taking only the Subject1 & Subject2 in the Dimensions . The data is also reduced to that level and I am unable to get the Total Students as 100.
How to display the total Students as 100 . Kindly help me to resolve the Total Students Column .
