Local Calculation (Summation) in query doesn't display correctly in web
I have been working on a complicated query where I have formulas that perform calculations. I then Hide these formulas and use them in another formula for further calculations. The new calculations I then use local summation to basically just add the columns values and come up with an overall result. Works perfect and is displayed perfectly.
Problem is now in the web. Either using a Pie Chart or just simply an Analysis item, the values are not displayed correctly at all. The Pie Chart only displays the first row of data (not the overall result...which is a local summation...which is what I would prefer) and suprised that the Analysis item doesn't basically display what the query does. I'm guessing it has to do with this local calculation.
Can someone explain this behavior?