Create parameter with int data type and select all
Create calculation as
Drag this calculation into filter and select true.
Show parameter and type your value and get orders.
Orders.twbx 1.2 MB
Filter works, but my cost needs to be sliced by another dimension (in columns) which adds up to the total cost (sales). So the filter filters individual values for one dimension and does not add to the total. I only want to filter on the total. I tried the calculated field with
SUM([Sales] >= [Cost] biut it returns an error.
Thanks so much!!!!
PS: Unfortnately I cannot open your workbook as I am working on v10.1