AS product hierarchy has too manny items

  • Hello,

    in our Company, we do have more than 3000 products. Since our Business is working with PowerPivot to filter Sales Amount by Product, they have to deselect all and select a couple of hundreds products which they want to look at (i.e. only products with sales values in germany).

    Is there a oppurtunity to create a filter based on the condition mentioned above? Or do you have a other approach?

    Thanks in advance and kind Regards

  • Create one (or more) user hierarchies in the dimension.

    Steve.

  • Thanks for the answer steve!!!

    I will try your approach. Thank you!!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply