cumulative calculation without filter action

0 votes
How to perform cumulative total for the table without the effect of filters? I have added a year as a filter and want to see the yearly avg sales and profir vs past all year data.
May 7 in Tableau by sindhu
8 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
Hi Sindhu,

You can have cumulative calculations without affecting filters by using LOD.

Syntax: { FIXED [FIELD_NAME] : AGGREGATION(FIELD) }

As per your question. we can find the average for all years.

{ FIXED : AVG([Sales]) }

similarly, profit as   { FIXED : AVG([Profit]) }

Place the created field in sheet to see the avg sales year wise vs all years.

Hope it helps you.
answered May 7 by CHERUKURI
• 12,780 points

Related Questions In Tableau

0 votes
1 answer

Action filter (on set) is appearing in my worksheet.

Those are the action filters that we ...READ MORE

answered Aug 17, 2018 in Tableau by AwesomeSauce
• 830 points
96 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 12, 2018 in Tableau by QueenBee
• 1,810 points
22 views
0 votes
1 answer

Is it possible to apply filter just to one of the measures

Hey @Ghost, Why don't you use Level of Detail ...READ MORE

answered Apr 17, 2018 in Tableau by Atul
• 10,190 points
17 views
0 votes
1 answer

Calculation issue: Distinct sum in Tableau

SUM( { FIXED [Brand], [Market]: AVG(Target) } ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 10,190 points
1,515 views
0 votes
1 answer

Creating a calculated field with LOD expression

Go ahead and try the following three ...READ MORE

answered Apr 20, 2018 in Tableau by Atul
• 5,470 points
54 views
0 votes
6 answers

How to use COUNTIF in Tableau?

I'll give you a brief idea on ...READ MORE

answered Dec 10, 2018 in Tableau by Haider
4,542 views
+1 vote
1 answer

Adding filter to LOD Expression

{ FIXED [Product]:COUNT(IF [Status]=0 THEN [Status] END)} Edit----- ...READ MORE

answered Aug 1, 2018 in Tableau by Atul
• 10,190 points
43 views
0 votes
1 answer

How to create a filter based on date range?

You can use this code snippet in ...READ MORE

answered Aug 7, 2018 in Tableau by Nitish
• 630 points
24 views
0 votes
1 answer

Filter via cell with multiple values

Hi, you can use string pattern matching ...READ MORE

answered Mar 4 in Tableau by CHERUKURI
• 12,780 points
12 views
0 votes
1 answer

How to get only the last n months action of all my records?

Hi Nithin, You can use Calculated field to ...READ MORE

answered Mar 8 in Tableau by CHERUKURI
• 12,780 points
31 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.