If I create a pivot grid and choose Field Settings "Count" for the Row Field, and click to View in Excel, it does not match what I see in the Aqua Data Studio Pivot Grid.
However, in the generated Excel, if I click Grand Total cell and then change its Sum value to "Count of Login", it will match Aqua Data Studio's pivot grid.
Is this a bug, or as designed?
See attached.
|
210 KB
![]() |
5 KB
|
191 KB
|
200 KB
![]() |
13 KB
|
131 KB
|
142 KB
|
180 KB
|
145 KB
There is a different issue with exporting pivot table field function to Excel 2007 without Data Fields.
This issue was due to the fact that ADS was not mapping pivot grid data field functions to Excel functions correction (it was attempting to map row/column functions of a data field which is never set).
There is a different issue with exporting pivot table field function to Excel 2007 without Data Fields.
This issue was due to the fact that ADS was not mapping pivot grid data field functions to Excel functions correction (it was attempting to map row/column functions of a data field which is never set).
Issue #10456 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS-14.0.4 |
No time estimate |
I used v12 and v14 to show this in the screenshots.