3 Replies Latest reply: Apr 9, 2012 9:40 AM by Stefan Wühl RSS

    Calculating a value on a level below the dimension.

      Hello,

       

      I am creating a dashboard that projects revenue by sales team for this year based on the growth we saw last year. The complex part of what I am trying to do is calculate this projection on a level below team ( say product category) and then add up each category for each team to get the value . I do not want to use product category as a demension since there are too many and it's too much to look at. Is there a way to do this?

       

      Any suggestions would be appreciated.


      Thanks,

      Jeff