Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I'm hoping someone can point me in the right direction, I want to do a calculation on a pivot table to work out the percentage for each item, so I need to get the value for the total of the row... i.e.
Product A Total: 4000
When expanded, you see the subtotal for each sub-product:
P1 2000
P2 1000
P3 1000
So my calculation would be:
P1 4000/2000
P2 4000/1000
P3 4000/1000
I've tried TOTAL, but I don't want the total for all of the products, just the product related to the sub-product.. Hope this makes sense!
Kind Regards,
Dayna
Can you try this, but plz check your set analysis expression as in addmonths 'mmm yyyy' it shows error:
sum({'$(=date(addmonths(today(),-1),'MMM YYYY'))'},CV_tr_type = {'ISS-WO'}>} CV_tr_qty_loc)
/
sum(aggr(sum({'$(=date(addmonths(today(),-1),'MMM YYYY'))'},CV_tr_type = {'ISS-WO'}>} CV_tr_qty_loc),SubProduct))
Still no joy I'm afraid, it just comes up blank.. I'll try and get an example application sorted. For the moment, I wouldn't worry about the full expression - just the total [ sum(aggr(sum({'$(=date(addmonths(today(),-1),'MMM YYYY'))'},CV_tr_type = {'ISS-WO'}>} CV_tr_qty_loc),SubProduct)) ] would be wonderful.
Many thanks for your continued help!
Kind Regards,
Dayna