Pivot table in sub total

[Anonymous]

Hi Expert

Hi Expert

I have attached my qvw file in my second expression (sellout %)  in bottom total  it is showing this sum of percentage value

	Sellout			Sellout %
Total	8,625	5,438	14,062	2,376%	1,624%	4,000%

But it has show like this in sub total. please help us how to fix it   something like 8625/14062, 5438/14062

	Sellout			Sellout %
Total	8,625	5,438	14,062	61%	39%	100%

[sunny_talwar]

Try this expression:

Sum(Sell_NDPCurrMth)/Sum(TOTAL <[Product Line]> Sell_NDPCurrMth)

[trdandamudi]

May be as below for sellout% expression:

Sum(Sell_NDPCurrMth)/Sum(TOTAL Sell_NDPCurrMth)

[Anonymous]

Hi Sunny

There is any other way  get it by using column "Sell_NDPCurrMthPercent". I have to use only this column for calculate % not Sell_NDPCurrMth. Just mentioned the sample to data. that % column calcaulted in DB on many business logic

[nagarjuna_kotha]

Try this

I hope this may helps you.

-Nagarjun

[sunny_talwar]

This is the best you can do:

If(Dimensionality() = 0, Sum(Sell_NDPCurrMth)/Sum(TOTAL <[Product Line]> Sell_NDPCurrMth),

Sum(Sell_NDPCurrMthPercent))