Dear All

I am using OWC10 to link to OLAP cubes and the grand totals are not reflecting the filter selections I make on the pivot (Row header / column header). This only appears to be a problem when I use the OpeningPeriod and ClosingPeriod MDX functions in OLAP

Can someone point me in the right direction on how to best control totals from OLAP into the Pivot Table component. My data source is essentially a time dimension (with default levels) and my measure is using the OpeningPeriod function

Thanks

Kind regards
Jame