Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have a pivot table and i m not getting expected results when i use Total function. Can anyone please help me to understand where i went wrong?
Please find attached document which explains my problem with example.
use Sum(Net)/Sum(Total <Group> Net) for your % column.
use Sum(Net)/Sum(Total <Group> Net) for your % column.
the sum total net should take into consideration the Group dimension
so your expression should be sum(Net)/Sum(Total<Group>Net)