Hi, When I display my Web Query with Rows as a hierarchy (data Provider Axis setting) I would like to prevent Key Figures from totaling up at the higher level. In this particular report it doesn't make sense to see the % column with a total. I know it's possible to do this when I don't have the report set up as a hierarchy, but I really like the hiearachy ability with rows, but I can't have the total!
*Can anyone help me with this? Full points for this one or Lunch on me.
See the link below for an example.