I have four different sets and want to add up all the sales for the companies which appear in any set.
When I use this formula :-
The total sales comes to 28,020,915 which is the total sales when they appear in the specific sets.
If I use :-
I get 33,274,647 which is the total sales of the companies if they appear in any set.
The sets are defined as :-
Why should the two formulas above give different results???
try to add () for each condition as shown below and see if you get the same figure or not.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...