Forum Discussion

nmhung49's avatar
nmhung49
Helper II
7 years ago
Solved

Report a Table like Excel Pivot Table

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

Need Help
  • rocky09's avatar
    rocky09
    7 years ago

    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..

     

     

     

     

2 Replies

  • rocky09's avatar
    rocky09
    Solution Sage
    7 years ago

    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..

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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