Please check this formula.
(SUM( IF [Segment]="Consumer" or [Segment]="Corporate"
Thanks for your reply.
If I want to have a function that it is calculated based on filter of date?
Sorry I didn't get a gist of your question. Could you please explain.
I mean if I add the order date in the filter and filter it (select certain date). Will the calculation perform accordingly?
Yes. It should work.
Thank you very much!
A question here.
Refer back to this example :
([Segment for Consumer and Corporate on Sales] / Sales )* 100
There are many consumer and corporate on a single day but only one total number of sales that day.
If i do left join, the total number on the single day will duplicate on each consumer and corporate on the particular day...
It will make the Sales to be very big isnt? Or it will not happen? Tableau will only apply the number of total sale on the single day?
Do you get me?