Skip to Content

CR 2013 Crosstab - Including calculated members in other calculated members and formulas

I have a requirement that includes a crosstab that displays some expenses(rows) that are manually entered by the user for 4 items(columns). I have exactly 10 rows of expenses that are available in the table but i need to insert about 10-15 others as calculated members and some of those calculated rows include values from other calculated rows so i'd need to use a calculated member in another calculated member and i haven't found a way to do this so far.

I thought about doing it from the query but the items are basically 4 tables so i'd need around 20 unions for each table in which some will include sub queries to include already calculated formulas in other formulas, technically it's doable but i am not sure that's the best way.

Any help would be appreciated.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 05, 2018 at 10:58 AM

    Hi Ashraf,

    You can refer to other Calculated Columns, ss long as the Calculated Members are in the "same" crosstab.

    Do you have an example (sample data) of what you want in the crosstab?


    Add comment
    10|10000 characters needed characters exceeded