Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to write an aggr expression but struggling with how to do it
Row: Paid Year
Column: Billed Year
Expression:
If the total Billed amount is greater than $50,000 for "company" than include the amount in the appropriate Paid Year/Billed year intersection of the pivot table.
Help?!
Zagwit
Hi,
Hopefully I understood the requirement correctly. Try below expression
SUM(IF(aggr(sum(Amount),Company, BilledYear, PaidYear)>=55000,Amount))
//Andrei
This is exactly what I want. However I am just getting "0" at all the intersections that should have values.
Thoughts?
Z