Actuals, Forecast and Difference in pivot table

[manas_bn]

Hello all!

Currently I have a horizontal straight table like this:

I need to create a table which is similar to the above, but it should have actuals, forecast and difference for each of the metric.

Something like this:

I tried creating a flag for Actuals and Forecast, but I am not able to create "Delta" for each of the metric. I have attached a sample for anyone who wants to help.

Thanks in advance,

Manas

[Lisa_P]

See attached for answer ...

[manas_bn]

Thanks Lisa, unfortunately this is not what I was looking for.

Both "Metric" and "Count" are 2 different measures. I need the Table to show like this, but also with the delta next to actual and forecast.

Consider Metric 1 to be Call Count and Metric 2 to be Membership Count. For each of these, I will need to show Actual, Forecast and Delta. Actual and Forecast is easy to show this way, but not Delta.

[manas_bn]

Any help, please..

[dplr-rn · Accepted solution]

Did you try replacing  flag dimension with valuelist custom dimension ?

ValueList() – For those tricky situations

[manas_bn]

Works great! Thank you.

[dplr-rn]

good to hear