Report a Table like Excel Pivot Table

[nmhung49]

In Power BI, I want to create a report table same pivot table in Excel

See the picture

 

How to be like that, with the format same pivot table in excel

Seet Attach file

Example.pbix

Example.xlsx

Thank you

[Anonymous]

My qustion is similar to this issue, but one more step.

What should I do if I want to do more calculations from the pivot tables.  For example,

I want to compute Anne Oct expense over Sep Expense, that is 112/191

Lucie Oct expense over Sep Expense, that is 109/122

Richard Oct expense over Sep Expense, that is 142/147

...
How can I do it in Power BI?

Thanks

[rocky09 · Accepted solution]

Hey @nmhung49

I tried and almost got as yours.

Steps Below:

1. I have used Matrix Table.

2. Arranged data as like in the First Image.

3. make sure to OFF Stepped Layout from Visual Formats.

4. Play with Values/subtotals etc..