Comparison of data with table calculation in value

Dear QS-Community,

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:

Then defined calculate as: Group across

Result is that I have empty columns in my chart (Δ costs) which does not look nice.

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.

Thanks
Dan

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:

Thanks for your reply.
Unfortunately this does not help.

The empty columns are still getting displayed.

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.

Let me know if you have any additional questions.

Hi @de.schmidd,
It’s been awhile since we last heard from you; following up to see if you had any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

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.

Thank you!