I am attempting to display the result of total sales but want to exclude 2 specific fields from the calculation where sales have been made - this is the expression I have used which I am sure isn't quite right:-
=Sum({$<Field1-={">$(=.00)"},Field2=>}Sales)
I have seen the thread below which will come in handy I am sure but a bit beyond my skillset just yet.
Say, you have three fields like Year, Product, Sales. Now,
sum( {$<Year = {“*”} – {2013}, Product = >} Sales ) // this will exclude the sales of 2013 irrespective of the selection in the year field, and for the Product dimension selection is ignored (all the products would be considered in the sales).
Say, you have three fields like Year, Product, Sales. Now,
sum( {$<Year = {“*”} – {2013}, Product = >} Sales ) // this will exclude the sales of 2013 irrespective of the selection in the year field, and for the Product dimension selection is ignored (all the products would be considered in the sales).
