Thank you for replying.
Q2: Just like I thought, columns in a Pivot can not be hidden, thank you for confirming my thoughts.
Regarding Q1: What I want to have done is:
- The first sum: 58.719.948 is SUM INCOME
- -18.084.228 is SUM COSTS
I have NO idea how to do this, and I have tried everything. I have a table where the number from the first column is connected to the text, but that is as far as I get...
Any ideas anyone?
You can change the text on the Presentation tab. Under Dimensions and Expressions, select the field for the text you want to change, and enter your text in the "Label for Totals" box.
I'm not sure exactly what you're trying to accomplish by hiding the columns. You can REMOVE columns, obviously. My guess is that you'd want to remove some columns, then use aggr() in your expression(s) to calculate totals as if the columns were still there. But without more specifics on what you're trying to do, I can't really give you an exact solution.