I’m using pivot table to display a cost value and cost % variation by category and sub categories.
However, in both fields it forces me to choose aggregation, so that when I collapse the category, the cost value does not correspond to the cost %. Is there a way to add fields without aggregation or to add an aggregation based on another field?
You can add it as a row, however it won’t show anything when you collapse.
In regards to adding aggregations based on another field, you can look into doing sumOvers, avgOvers etc and partition by other fields.
Let me know if either of those ideas help.