Hello All,
The user wants to see the same characteristics in the report in each of the row. For example, the intial run of the report shows Material and quantity. The user then drills down the report by Plant. We are having Multiple plants for each material. So, when exported to excel, we do not see material against each plant. This is having problems when filtered by plant.
How it looks now:
*********************
Materail Plant Quantity
123 A 200
B 300
C 500
Below is how users want:
******************************
Materail Plant Quantity
123 A 200
123 B 300
123 C 500
What are the settings we need to make to acheive the above? Where should I make changes? I have "Unchecked" the option
Hide Repeated key values in Query properties. This did't
work 😔
Please help me.