Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Persantage in Pivot Table


Hello,

I am trying to build a report in pivot table that calculate the sales summary and the % for each month grouping by style, color and size.

in order to calculate % I am using expression as following:

.Sum(qty)/sum(total <style,color,csize> qty)  , but getting wrong result.

Please see the attached excel file.

What am I doing wrong? Thank you

1 Solution

Accepted Solutions
SergeyMak
Partner Ambassador
Partner Ambassador

Hi Denis,

I think you just need change csize to Month in your expression

Sum(qty)/sum(total <style,color,Month> qty)

PFA an example

Regards,
Sergey

View solution in original post

2 Replies
SergeyMak
Partner Ambassador
Partner Ambassador

Hi Denis,

I think you just need change csize to Month in your expression

Sum(qty)/sum(total <style,color,Month> qty)

PFA an example

Regards,
Sergey
Not applicable
Author

Hi Sergey,

Yes, I have already solved it by doing this.

But thank you very much for your respond.