i am trying to do total and subtotal for the hierarchy field but it should restrict duplicate data.
Item code subtotal = 40,80,40
Order Num sub total = 120,40
But State total should be 140, because itemcode1 repeated twice it should be consider only once.
i tried using size() functionality get the results but i am unable to get the results.
IF SIZE() =1 THEN SUM(SALES) END
Can some help me.
Not sure why state total should be 140 as my understanding is, itemcode1 is repeated, so the total should be 120 as shown below my calculaiton2
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...