Basically, I have a PT with Weekday on the vertical and Hour along the horizontal, with average sales as the value (see attached).
The first PT shows average sales - this works fine. The second PT should show the figures as a % of the Weekday total i.e. sum(sales) / sum(total <Weekday> sales). So, for Mon 08:00-09:00, the calculation should be 98/1002 = 10%. But for some reason, all values are 100% !
I have a calculated dimension which may have caused a problem, but I don't see why it should interfere. I can do sum(sales) / sum(total <Hour> Sales) i.e. % of column, which works fine. But % of row doesn't. I can't see what the problem is.
I too can get it to work without the calculated dimension. The reason I used a calculated dimension is because Hour is a text field (e.g. 09:00-08:00) and I need to restrict the min and max on my chart. Because it's text , setting the min and max values in the object does not work.
Anyway, I think I will try to overcome the problem by removing the calculated dimension and placing the calculated element of the dimension into the expression. I had done this initially but it caused other problems.
I don't understand the post in your thread. Perhaps if you attach a test app it will make more sense to me.
Sorry I couldn't be of more help. Maybe you should repost thread, as other users may have thought your issue was being sorted by my response? Not sure if it works like that.
Many thanks for your offer - in fact I noticed that I had created a data island when merging the 2 cells in a separate load statement. So i moved the merge into the earlier load statements and all seems to work fine!
Can I ask you something? I have Personal Edition, so was unable to open your .qvw file, which also seems to have been created in .Personal Edition. My question is - if you have Personal Edition, is there a way to open .qvw created by other users?
