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

     

     

     

     

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