Dynamic Subtotal on Local Member

[former_member186316]

Hello Everyone,

I want show dynamic subtotals on local member  in a report .Could anyone give us suggestions on how to solve this issue?

Here Therapy ,Container are local members ,we need subtotal on Therapy wise and also Container grouping should be done as per Therapy wise  for subtotal  .

Thanks In Advance

--GANAPATHI

[former_member186338]

Sorry, but what do you mean by "Therapy ,Container are local members"? Can you provide details about dimension members?

[former_member186316]

Hello vadim ,

Thanks for quick response.

Those two local members are properties  of Product DIM and displaying those properties as local members with reference to Product DIM Members .

----Ganapathi

[former_member186338]

And where are the members? In some hidden column? Have you used sorting and grouping by property? Or?

Please, provide detailed info not to waste the time...

[former_member186316]

Product DIM Members should not be visible in report .I had applied  Sorting And Grouping on Product DIM via property "Therapy ",but no use

Here is the sample reference

[former_member186338]

And what hierarchy do you have for product?

[former_member186316]

There is no  Std hierarchy maintenance for product 

[former_member186338]

And in general I recommend to use hierarchies and extra dimensions instead of properties. Properties are not for aggregation!

[former_member186338]

That's the issue!