Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
i have created Pivot table to with two dimensions, i have added partial sum for one dimension, i could see total name reflecting twice in pivot table twice(please refer below screenshot). kindly suggest me how to remove duplicate sub total name.
Thanks in Advance,
NR
Really need the QVW file on this one to try to help you, if you have sensitive field info, you can use the Settings\Document Properties\Scrambling tab to scramble that information prior to posting. Folks need to be able to see the chart properties and data model in order to be able to try to determine what may be occurring here.
Regards,
Brett
please check partial sums checkbox for your dimensions:
Right click diagram > properties
presentation tab > choose dimensions one by one and check checkbox "show partial sums"