Aggregate Dimension Values

[malimohammed]

We are to show the aggregation of Product Levels in the following way

Product Level is a dimension and has two values: 030 and 040. We are to show the Rows in a straight / pivot chart as follows:

Row 1 - 030 – sum of sales(of 030)

Row 2 – 030 and 040 – sum of sales(of 030 and 040 combined)

Is there an easy way to combine dimension values? Should we make a resident table and then sum the values?  This is flexible we just have to show whether we are able to perform something like this? Combination of two different values.

Will really appreciate your assistance on this.

[MK_QSL]

Consider that you have below table

Load * Inline

[

  Customer, Product Levels, Value

  A, 030, 100

  A, 040, 120

  B, 030, 200

  B, 040, 220

];

Create a straight table

Dimension

Customer

Product Levels

Expression

IF([Product Levels] = '030',SUM({<[Product Levels] = {'030'}>}Value),

IF([Product Levels] = '040',SUM(TOTAL < Customer> Value)))