Hi All,
My EPM version is EPM 10 SP32. I wanted to create a BPC report below:

EPM can sort a dimension property only in the option Member Sorting & grouping, and then EPM Local Member cannot create subtotals like the above example. I cannot put static members in the field Product because the report always has different members.
What should I do to create the above report?. Help me, please.