search

mysticfall / pivot4j

Pivot4J provides a common API for OLAP servers which can be used to build an analytical service frontend with pivot style GUI.
Other
128 stars 101 forks source link

removing the All Dimension but still maintianing totals #192

Open rdavi10471a2 opened 8 years ago

rdavi10471a2 commented 8 years ago

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 image

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

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 commented 8 years ago

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 commented 8 years ago

yes adding row/column totals worked thanks