Hi WebI experts,
I searched in multiple forums to get the answer but I was not able to . Please help me how to overcome #Multivalue issue .
I have 2 queries .
Query 1 - 3 dimensions and 1 measure
Plant Material Category Stock
Query2 - 4 dimensions and 2 measure
Plant Material Month Date NetQty Price
I made both Plant and Material as merged dimensions. I am using cross tab (month,date in columns)
When I adding Category to Merged Plant and Material it is giving #Multivalue issue.
If i remove one merged dimension from output then it is working if I create variable(category) with detail. But I need both merged dimensions in output.
Category depends on both Plant and Material combination. So please help how to put category in the output.