Hi ,
I'm just a beginner on Tableau and was trying to figure out what is used instead of an over function on Tableau. Like say for example lets consider this simple table. I want to insert a new calculated column that would find the Sum of sales over each individual category. What would the expression be like.? Please help..
Date | Category | Sales |
01-01-2016 | tables | 20 |
02-01-2016 | Chairs | 10 |
03-01-2016 | Benches | 15 |
04-01-2016 | tables | 25 |
05-01-2016 | Chairs | 30 |
06-01-2016 | Benches | 10 |
07-01-2016 | tables | 20 |
08-01-2016 | Chairs | 15 |
09-01-2016 | Benches | 10 |
10-01-2016 | tables | 60 |
11-01-2016 | Chairs | 35 |
12-01-2016 | Benches | 15 |
Hi Varsha,
Try level of detail expression
{FIXED Category : SUM(Sales)}
Refer the following link for more details.
Overview: Level of Detail Expressions
-Joyson G