I am working on the report retail → Sales performance by category by store report.
In that report, DynamicsAXOLAP used as datasource.
I need to add drill down for style under child category node.
I have added the [Styles].[Styles].MEMBERS in the row section in the MDX query.
Group created for category id and recursive parent [parent category id] mentioned.
Please help me that how to add the style under the end child category?