ncuz
May 25th, 2009, 05:08 AM
Hi all,
With the title, I would like to know whether it is possible to export the data from the OWC pivot table components to excel file?
Because I have been struggling with this for more than a week and I couldn't find a suitable answer to this problem. For the original export that attached to the pivot table is not the answer that I am looking for because that export is only exporting the row axis, column axis and filter axis. While the one that I am looking for is to export the entire layout as the excel layout (removing the pivot table feature from the excel). Which means that I will need to know each of the field and the sub field (or the second field and so on) and also the data member that is attached to the sub field.
I really need help in this as I don't know what else to do to solve it. Thank you very much for your help.
With the title, I would like to know whether it is possible to export the data from the OWC pivot table components to excel file?
Because I have been struggling with this for more than a week and I couldn't find a suitable answer to this problem. For the original export that attached to the pivot table is not the answer that I am looking for because that export is only exporting the row axis, column axis and filter axis. While the one that I am looking for is to export the entire layout as the excel layout (removing the pivot table feature from the excel). Which means that I will need to know each of the field and the sub field (or the second field and so on) and also the data member that is attached to the sub field.
I really need help in this as I don't know what else to do to solve it. Thank you very much for your help.