Pivot Chart sum from a single column but two different values

[Jryacr]

Hi,

newbie question.. I'm trying to setup a pivot table where each row in a column gets its own total value after subtracting from two different values in a column ( I don't know if it makes sense). Screen shot below

[Kushal_Chawda]

You can do it using following approach.

Create one inline table in script

Dim:
LOAD * Inline [
Dim
1
2 ];

Now in pivot table, Just replace the  [Key Figure] Dimension with below calculated dimension

=pick(Dim,[Key Figure] ,'Total')

Rest all dimension and expression of the pivot table will remain as is.

[Jryacr]

This is really helpful Thanks!!!!… we are getting some where!!!!...How can I subtract instead of adding the value....screenshot attached.

Regards,

[Kushal_Chawda]

 it forecast-sales or sales-forecast ?

[Jryacr]

Spoiler

 Final Forecast Qty - Sales History Qty

[Kushal_Chawda · Accepted solution]

Dim:
LOAD * Inline [
Dim
1
2 ];

[Key Figure] Dimension:

=pick(Dim,[Key Figure],'Total')

Expression:

=pick(Dim,Sum(Value),sum({<[Key Figure]={'Final Forecast Qty'}>}Value)-sum({<[Key Figure]={'Sales History Qty'}>}Value))

Note:

Here I have assumed your expression is Sum(Value). You can change your expression accordingly

[Jryacr]

Thank you Sir!!!! you are the best. I had to play around with "Sum(Value) it was giving me an error on the expression, but I was able to fix it...Thanks and Regards!