# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted Partner

## Calculation of Share% in Pivote

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

1 Solution

Accepted Solutions
Valued Contributor

## Re: Calculation of Share% in Pivote

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

3 Replies
Valued Contributor

## Re: Calculation of Share% in Pivote

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

Jonathan

Valued Contributor

## Re: Calculation of Share% in Pivote

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!!!! Partner

## Re: Calculation of Share% in Pivote

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