locked
add total RRS feed

  • General discussion

  • Hello,

    I have a pivotable in powerpivot with an unknown column.

    I need to add the categories of the unknown column on the extreme right hand side and need to add (blank + f + m)

    I also have a drilldown category and date.

    I have tried using cubevalue but this hardcodes values and does not cater for the drilldown values.

    Please advise on steps to resolve this 'simple problem' URGENTLY.

    eg           

                               0 - 5                  5 - 10           unknown

                           m      f                 m      f              blank m f

    category 1        5    5                 3      8              7      4   6

      2010               2    2                 1       4             4       1  3

       2011              3    3                 2       4             3       3   3

    category 2      10    2                 2        2             4       2   1

      2010             5      1                1         1             2       1   1

      2011             5       1               1         1             2       1   0

    Monday, October 15, 2012 11:49 PM

All replies