How to arrive new dimension using already loaded dimension

[vikasmahajan]

Hii

I have  following data

Actual  & Plan dimension and units and values in pivot , now I want to arrive dimesion c = Plan - actual

how to arrive.

Thanks

Vikas

[sunny_talwar]

This is needed as a dimension or Expression? And are you trying to do it in a pivot table as a calculated dimension or in the script?

[vikasmahajan]

Test qvw is attached please find and i want it in script

Vikas

[MK_QSL]

Mytab:

LOAD * INLINE

[

  Cat,Qty

    Planned, 1000

    Forcast,2000

    Planned, 3000

    Forcast,6000

];

Concatenate

Load * Inline

[

  Cat

  NEWCATEGORY

];

Use below expression..

IF(Cat = 'NEWCATEGORY', sum(TOTAL {<Cat = {'Planned'}>}Qty)-sum(TOTAL{<Cat = {'Forcast'}>}Qty),sum(Qty))

[vikasmahajan]

Thanks Manish I will check and reply

Vikas

[vikasmahajan]

Hii,

Manish,

Suppose I have 2 more dimension below cat dimension like grp1,grp2 then result will come same ?

Vikas

[vikasmahajan]

should I use aggr ?

[MK_QSL]

Provide data.. I can't reply without checking !

[vikasmahajan]

attached new qvw

[MK_QSL]

Can I have the result also which you are looking for your new file?