Hello,

is it possible in targit to add a row calculation to a cross tab that uses a dimension attribute that is not used in cross tab and do something like this:

1. calculation row: sum amount if dimension attributekey < 9000
2. calculation row: sum amount if dimension attributekey < 10000
3. calculation row: sum amount if dimension attributekey < 15000

Thanks in advance for your help

Best regards
George

Hi George,

To elaborate on Lotte's idea, in the 2019 version you can do this with a User Dimension where you can work with the new concept 'Custom values'.. Also the attributekey numbers need to be available as a proper dimension attribute in the TARGIT client's Source data.

The User Dimension's four members can be designed in this way:

- A Total member (a member where you just click OK without selecting any criteria - this will show all the data).
- A member, based on the dimension attribute, with a Custom value < 9000
- A member, based on the dimension attribute, with a Custom value < 10000
- A member, based on the dimension attribute, with a Custom value < 15000

This will produce four columns in the crosstab. You may want to go to Properties / Visibility to hide these, except the first (Total) column.

Each of the three hidden columns can be referred as d2, d3 and d4 respectively in a calculated row. E.g. sum(d2, all, m1) and sum(d3, 0, m1) and sum(d4, all, m1).

BR / Ole