Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I am struggling with what should be a relatively simple issue. In Excel, using Power Pivot or a pivot table, I can select which columns where I want subtotals to appear. I have a measure that sums financial values with filters. The rows in the table are organized using a financial coding dim table that has several tiers for organizing financial data. For instance there is a sort column that organizes the data into a specific order (that matches the client's current reports), a high level category like "Income", a second tier category such as "rental income" and then a 3rd tier which breaks down the rental income by cost or accounting code. I want to subtotal by the 2nd tier only but when I select the subototal for rows I am getting either a subototal for each cost code or multiple subtotals.
Hi @7iOG, people will be able to help you better by providing a sample data and how you want the result to be.
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
86 | |
83 | |
74 | |
49 |
User | Count |
---|---|
142 | |
141 | |
110 | |
69 | |
55 |