- Self union your data
- You get a Dimension Tablename
- Create below Calc
- If Tablename="Data" Then Your Dimension ELSEIF Tablename<>"Data" and Your Dimension="A" OR Your Dimension="B" OR Your Dimension="C" THEN "LRB" END
- Use this New Calc as Dimension and you are done
Are you saying, if the value is in this list: CSD, CSD MS, CSD SS y COLAS CSD
then sum up everything into one total, otherwise leave everything else as it is?
Do you also want to show the individual rows of those values in the same viz?
Yes, i need also to show the individual values.
did you try above?
I created a sum of Discount and Taxes at Top using sum of Discount and Taxes
If it Helps, Pl mark it Helpful and CORRECT to Close Thread
new Dim.twbx 24.6 KB
Deepak!, That help me, this is the solution. I did the union in PREP.