Calculating a value on a level below the dimension.
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?