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

    pedropablo.rodriguez

      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!