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, 2019 in Tableau by sindhu
829 views

1 answer to this question.

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, 2019 by Cherukuri
• 33,030 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
• 860 points
2,358 views
0 votes
1 answer

How to create a global filter

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

answered Apr 13, 2018 in Tableau by QueenBee
• 1,820 points
1,431 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,240 points
1,426 views
0 votes
2 answers

Calculation issue: Distinct sum in Tableau

I feel the easiest way is to ...READ MORE

answered Aug 26, 2020 in Tableau by Dhiraj Kumar Sahu
9,530 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 ffdfd
• 5,550 points
1,094 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
36,252 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,240 points
981 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 8, 2018 in Tableau by Nitish
• 630 points
936 views
0 votes
1 answer

Filter via cell with multiple values

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

answered Mar 4, 2019 in Tableau by Cherukuri
• 33,030 points
886 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, 2019 in Tableau by Cherukuri
• 33,030 points
669 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP