5 Replies Latest reply on Jan 4, 2019 10:43 AM by pedropablo.rodriguez

# Add a Category in a dimention from the sum of some of them

Hi!

do yo know if Is it possible create a category in a Dimention, where i use some categories, sum some categories, to create a new category?

for example, i need a new category, that names LRB (first line), that line is the SUM of come categories bellow. In the picture I put the COMUMN TOTALS, but it sum all the rows, i need only sum the first 5 rows (for example CSD, CSD MS, CSD SS y COLAS CSD), in the same table

how to calculate in PREP or in desktop?

Regards and thanks!

• ###### 1. Re: Add a Category in a dimention from the sum of some of them
• You get a Dimension Tablename
• Create below Calc
• Use this New Calc as Dimension and you are done
• ###### 2. Re: Add a Category in a dimention from the sum of some of them

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?

• ###### 3. Re: Add a Category in a dimention from the sum of some of them

Yes, i need also to show the individual values.

• ###### 4. Re: Add a Category in a dimention from the sum of some of them

did you try above?

• ###### 5. Re: Add a Category in a dimention from the sum of some of them

Check this:

I created a sum of Discount and Taxes at Top using sum of Discount and Taxes

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to Close Thread

1 of 1 people found this helpful
• ###### 6. Re: Add a Category in a dimention from the sum of some of them

Deepak!, That help me, this is the solution. I did the union in PREP.

Thanks!