Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a question.
I have a pivot table with no dimension and two expressions.
The result is like this:
Is it possible to omit the top part (blue circle), if possible how can i do this ?
Thanks in advance.
Go to properties tab of the pivot table and select "No Totals" under the "Total Mode" box. Hope this helps...
Hi Chou,
Go to Expression Tab, Select the "No Totals" for both Expression under "Total Mode" option.
Hi Chou,
First give a label to you expression if required. Then select "No Total" .
A sample screenshot below.
Regards
KC
You can UN-check Partial Sum too. Try Luck because above 2 replies are rocket grow