Back
I want to create a report with the following data
Item | Price | DifferenceA | 1.00 | 0B | 2.00 | 1.00C | 0.50 | -0.50
Item | Price | Difference
A | 1.00 | 0
B | 2.00 | 1.00
C | 0.50 | -0.50
How can I get output in this way
A | 1.00 | -1.00B | 2.00 | 0.00C | 0.50 | -1.50
A | 1.00 | -1.00
B | 2.00 | 0.00
C | 0.50 | -1.50
Check with the following calculated feilds
"Get parameter select price" = IF [F1 Parameter] = [F1] THEN [Price] END
"Parameter Selected Value for all rows" = {FIXED: MAX(IF [F1 Parameter] = [F1] THEN [Price] END)}
"Difference" = [Price] - [Parameter Selected Value for all rows]
Want to be an expert, check the tableau certification course
30.9k questions
32.9k answers
500 comments
665 users