I want to compare costs in a pivot table chart.
Therefore I´ve added the cost field from the dataset (AmountLECurr) two times into the section “values”
upper one is renamed in the chart to “Δ costs”
the one below is named “Salary” in the chart
Then I´ve added for the upper one a table calculation:
Do you have any ideas to improve this?
I do not have that much programming skills so if there is a native and simple solution I would be very grateful.
Hi @de.schmidd,
What if you tried hiding that field? I’m not sure the affect it will have on your totals/table calculations but this would be the work around option for this type of case:
Hi @de.schmidd,
When you expand your sections (LegalEntityID), are the fields still blank?
I think the best way to get around this would be to make a calculated field and use that in your table instead of running a table calculation. I’m not sure how you’re partitioning your fields to get the difference but you can look in to using the sumOver function for each field since you’re using partitions.
Hi @de.schmidd,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.