So I have a powerpivot chart on an excel 2013 file that pulls information from an Access database through powerpivot.
Only catch is that the chart uses an unpivot table to filter results.
It works fine in Excel, but we are trying to load the file to onedrive as our client has excel 2007 and does not have powerpivot.
In onedrive, the chart works fine, except in the case of the very last item filtered. Instead of reporting the correct value it shows some other random value, that we cannot figure out how it calculated or what it represents.
Does anyone have an idea of how to fix this problem?
Only catch is that the chart uses an unpivot table to filter results.
It works fine in Excel, but we are trying to load the file to onedrive as our client has excel 2007 and does not have powerpivot.
In onedrive, the chart works fine, except in the case of the very last item filtered. Instead of reporting the correct value it shows some other random value, that we cannot figure out how it calculated or what it represents.
Does anyone have an idea of how to fix this problem?
