powerpivot importing question

[matteo86]

Hi, I d like to know if I can import datas coming from calculated fileds. For example I want to import the field "remaining amount", that is calculated (on Microsoft NAV, the software I am using) by the difference between "invoices" and "payment". The problem is that, after I import the related chart from Microsoft NAV , the "remaining amount" field is not available. I am sorry if I was not enough clear.

 

[MD610]

Could you just add it as a calculate column directly in PowerPivot?

If only "invoices" and "payments" will import to PowerPivot, you could recreate the calculated column in PowerPivot using =[Invoices]-[Payment] since it is such a simple calculation.

Whenever you update the data, this value will recalculate.

 

[matteo86]

Could you just add it as a calculate column directly in PowerPivot?

If only "invoices" and "payments" will import to PowerPivot, you could recreate the calculated column in PowerPivot using =[Invoices]-[Payment] since it is such a simple calculation.

Whenever you update the data, this value will recalculate.

This could be a good idea, but since I need to import tons of charts in order to show them directly, is possible to do that?

 

[matteo86]

This could be a good idea, but since I need to import tons of charts in order to show them directly, is possible to do that?

answer please...