Excel 2019 wrong subtotals from SSAS cube

Oussama KHEMIR 1 Reputation point
2022-02-17T09:34:48.643+00:00

I don't understand why Excel doesn't show the same subtoals as ssas ?

Excel 2019 SSAS 2017

175297-image.png

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,274 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Alexei Stoyanovsky 3,416 Reputation points
    2022-02-17T10:30:30.207+00:00

    The first suspect for the highlighted difference is PivotTable Options - Totals & Filters - Subtotal filtered page items

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.