Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to find the percent of row total for a pivot table...
my table looks like this
Year Month Place Home Work School Total
1 Jan % % % 100%
2 Feb % % % 100%
3 Mar % % % 100%
My dimensions are Year, Month, and Place and my expression should be the %..
Can anyone help with this?
Not sure, What your intend? Can you explain little more using data set.
Hi,
Can You Try This May Work
Sum(Measure)/Sum(TOTAL <MonthField> Measure)
or this
Sum(Measure)/Sum(TOTAL <Year, Month> Measure)