Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi Sergey,
Yes, I have already solved it by doing this.
But thank you very much for your respond.