PBI table have 4 column after export it only have 3 column ?

[Paulyeo11]

Hi All

I need to export below table to excel :-

After export i get below :-

Can some one advise me how to make above table same as PBI table ?

Below is my PBI file :-

https://www.dropbox.com/s/lwjg511vq6suvn5/AR_ISDN%20v006%20ask%20how%20to%20eport%20table%20V002.pbi...

[PhilipTreacy · Accepted solution]

Hi @Paulyeo11 

1. Export the data from the visual - this is a CSV

2. Open the CSV in Excel

3. Create a table from the data

4. Insert a pivot table using the table as the source

5. Put Customer/Vendor name in Rows.

6. Put AGING in Columns

7. Put A/R amount in Values (this will automatically SUM values by default)

8. Done.

The amount of data exported from the visual is very small but the process is the same if you had 100,000 rows of data.

Phil

[Paulyeo11]

Hi Phil

Thank you very much for your effort. Excel is very user friendly. 

Paul 

[PhilipTreacy]

HI @Paulyeo11 

Here's the Excel workbook 

The pivot table is on the sheet named paulyeo11

regards

Phil

[Paulyeo11]

Hi Phil

Can you pls share with me how you create the excel ?

That is what i am looking for.

Paul

[Fowmy]

@Paulyeo11 

You need to create a pivot table in Excel to get the same layout.

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Paulyeo11]

Hi All 

Thank you very much for all your sharing . 

can some one share with me how to covert the 3 column excel To 4 column excel pls.

Paul

[PhilipTreacy]

Hi @Paulyeo11 

The data that creates your matrix is from 3 columns, that's what you get when you export the data.  The matrix just displays it in this way in PBI.  You can create a pivot table in Excel to replicate the matrix visual.

Phil