Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QV experts!
Hoping to add a column that can provide % CQ product or % of CQ renewals relative to CQ total in this pivot table.
I've tried this expressions:
=sum(if(InQuarter(SalesOrderDate, Today(),0),Amount))
/
sum(TOTAL(if(InQuarter(SalesOrderDate, Today(),0),Amount)))
However it provides the % relative to cumulative (column) total.
Your help would be much appreciated!
May be this
=Sum(If(InQuarter(SalesOrderDate, Today(), 0), Amount))/
Sum(TOTAL <Theater, Area, SalesManager> (If(InQuarter(SalesOrderDate, Today(), 0), Amount)))
May be this,
SUM(Amount)/SUM(TOTAL Amount)
OR
sum(Amount)/above(total sum(Amount)).
OR
SUM(Amount)/SUM(TOTAL <URDimension> Amount)
May be this
=Sum(If(InQuarter(SalesOrderDate, Today(), 0), Amount))/
Sum(TOTAL <Theater, Area, SalesManager> (If(InQuarter(SalesOrderDate, Today(), 0), Amount)))
Sunny!! Thank you! You are correct!
The multiple dimensions in the pivot were a little confusing.
Thanks once again for your help!