Pivot table measures in rows move to columns after conditional dimension update
It is my first post on this forum, but I used it a lot in the past and it answered a lot of my questions. But for this one I couldn't find the answer.
I created a PIVOT report, which has some conditional dimensions that are enabled or disabled if a user selects data from a list table. And it works properly, but whenever I change a dimension, measures are moved from the row section to the column section. It is hard to describe it, so I posted a video, where this issue appears.
Could you test the QVW. Made it up very quickly with demo data. There are many ways to implement ad hoc reporting and I cannot see what your solution is. Therefore it is hard to help you, but if you can test the qvw and see if the result is the same then we can take some steps to narrow the problem.
Thanks for a fast reply. I followed your suggestion and created a new report on Dummy data that uses the same solution, and it seems to work properly on my local computer, but when doing the same thing on server, the issue remains. Server is running on older version, so maybe that is the reason for this issue. I will investigate it further and come back to you when I find the solution.
Thanks again for another hint, but this doesn't seem to be the problem in my case. I was testing it using the app and I am almost 100% that the issue is due to the QV version. The test file that you suggested to create, works properly on my local computer (QV version 12.50.20300.0), but on the server or on the other user computer (QV version 12.20.20300.0) the issue exist.
I am attaching the test file in case someone would like to test in case they have the same problem.
Unfortunately it will take some time to update the server version, but once it's done I will check it and inform if the topic can be closed.