Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agastyamahi
Starting Member
33 Posts |
 Posted - 2014-01-13 : 20:54:50
|
| Hey All, I am working on excel pivot table and here is the issue. Sample Data: Prj 30Days 60Days GreaterThan60 128139 0 0 118484.02 123123 0 0 10115.01 234232 0 0 4609.81 121313 0 0 314.33 343432 0 0 4000 232323 0 0 164.27 121212 164994.98 0 0 232323 0 0 1046.58 Grand Total 1075731.89 535507.27 199200.01 Expected Result:Prj 30Days 60Days GreaterThan60 GrandTotal128139 0 0 118484.02 118484.02123123 0 0 10115.01 10115.01234232 0 0 4609.81 4609.81121313 0 0 314.33 314.33343432 0 0 4000 4000232323 0 0 164.27 164.27121212 164994.98 0 0 164994.98232323 0 0 1046.58 1046.58Grand Total 1075731.89 535507.27 199200.01 1810439.17I am getting the Grand Totals below as Grand Totals for columns, I also need the grand totals for rows as a right most column. I am not getting this, though I checked the option as SET Grand Totals for both rows and columns. I researched about this issue online and it says that we need to have at-least one field in Column Labels to get the Row Totals, I don't have any field in Column Labels. Could any please let me know if there is a way I can create a calculated measure for this, if so how can I create since I am new to MDX ? I also checked about created a calculated field in excel under PivotTable/Options/FieldItems and Sets/New Calculated Field. But the New Calculated Field option is disabled in my excelAny help would be greatly appreciatedThanks |
|
|
|
|
|
Need help with a pivot table issue