Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
Test qvw is attached please find and i want it in script
Vikas
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))
Thanks Manish I will check and reply
Vikas
Hii,
Manish,
Suppose I have 2 more dimension below cat dimension like grp1,grp2 then result will come same ?
Vikas
should I use aggr ?
Provide data.. I can't reply without checking !
attached new qvw
Can I have the result also which you are looking for your new file?