Calculation of Share% in Pivote

[prasad_dumbre]

Dear All,

I have attached sample .QVW with data, In this I want find contribution of each category with respect to total.

So, in Layman term formula is: Amount/Total Amount.

Can you please guide me how to do this . . .

Thanks in advance . . .

[Anonymous]

I assume you mean the total of each week. Please find attached if that is the case.

Jonathan

[qlikpahadi07 · Accepted solution]

Hi Prasad,

I think you need a Contribution with Weeks

Sum / Total is like

sum(Amount)/sum(TOTALAmount)

and if you add few more Dimensions just add this

sum(Amount)/sum(TOTAL <Week> Amount)

i think this might help you  find the attachment

Cheers!!!!

[prasad_dumbre]

Thank you Rohit & Jon , for such quick reply . . .