Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
may one of you can help me.
I have a pivot table and use "show Partial Sums".
I get the Partial Sums for all values in the dimension,but for one it is missing.
Do you have an idea?
Regards,
Lukas
Do you have a dimension or expression without a label? If so make sure you select the "blank" row in the Dimensions and Expressions setting in your PIVOT TABLE PROPERTIES AND select Show Partial Sums for everything.
Hope this helps,
Jason
Hi,
Please attach a sample file if u change straight table u will get answer.
Chart - > Propertities ->Total Mode -> Sum and Presentattion its may helpful.
Regards,
Iyyappan