Sum of Row Values in Pivot Table

[Dayna]

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

[neetu_singh]

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))

[Dayna]

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