removing the All Dimension but still maintianing totals

[rdavi10471a2]

suppose I am filtering down to specific stores, I want to see the totals for those stores rendered how do I do that? Otherwise great work... sure I am just overlooking something

the CA total is not equal to the total of the selected stores..

essentially I think a drilldown or filter operation should always show a grand total at the bottom.. and or be reflected in the all group.. please educate me othrewise...

Please advise

[mysticfall]

I must admit that I'm not an OLAP expert myself, but if I'm not mistaken, it's how it's supposed to work with the kind of MDX it generates.

However, Pivot4J also supports client side aggregation feature which works independently of the MDX statement used, which can be accessed from the toolbar menu of the Analytics application.

So, please try it and see if it resolves your problem and let me know if you need further assistance.

Thanks!

[rdavi10471a2]

yes adding row/column totals worked thanks