PFA for Sample data. In that Red color marked is what i need achieve .
IF Amount 2 > = 0 Then show Max of c + Max(Amount 3) (Total using Sum) Else Show Max(Amount 3) (Total using Sum) END.
Please kindly adivice how to sum 2 totals across cell (only totals) not values . i need to capture the total values and sum up in grand total row. please look into the spread sheet for example.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...