How to create a pivot table from a data model?

[Syndicate_Admin]

Good evening dear community!

I have a problem when I try to create a Accounting Income Statement report in a pivot table, starting that I have 3 Excel files and I am importing the data into Power Pivot, relating all the tables to a Chart of Accounts table.

When I make the pivot table from the data model and select the accounts so that they appear in rows and then the values of each of the items (Income, costs and expenses) it is perfectly associated with me, the problem is that for each data source the pivot table segregates them into different columns and I need to have all the values in a single column, that is, since I have 3 data sources (Income, costs and expenses) because the structures of each one are different, then in the pivot table it shows me the accounts and values segregates them into 3 columns. What can I do to make the values in a single column?

[Johnjose]

hey try to append the all the sheet, might you'll get. 

[Syndicate_Admin]

Hola @Syndicate_Admin

I managed to see the video and the data is on a single sheet, that way there is no problem in classifying the Result Statement by accounts and presenting it in a single column. My case is that the information by accounts comes from different sources and when I make the pivot table, a column is formed for each of the sources it has.

Here are the various origins I'm talking about:

and the result of the dynamin table:

The result I need is something like this, but in a single table and a column queue.

Thank you very much for taking the time to help me, I thank you very much.

[v-shex-msft]

Hi @MichaelGuido ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[MattAllington]

Financial statements are not trivial. Here is a presentation I did on how to do it using a Chart of Accounts and a GL

https://exceleratorbi.com.au/build-a-pl-with-power-bi/