Custom MDX Query for Excel Filters

Custom MDX Query for Excel Filters

More Often we may want to write custom Filters for Cube Data retrieved through Excel. You can achieve it through VBA or simply by adding few iterations on Excel. We can Achieve Custom calculations by simply adding OLAP PIVOT TABLE Extension to EXCEL .

A common scenario would be building a 13 week rolling window for Pivot report on Excel.