Joined: 04 Mar 2008
Location: United Kingdom
Online Status: Offline
Posts: 70
Topic: Unwanted Cross-Tab Totals in v10 Posted: 13 May 2009 at 2:52am
Getting these for YEARS and can't see a solution!! Sure there's suppressed totals and zeros but it seems assumed that in cross-tabs you will always get multi rows and therefore you want to show a total on the rows.
For every good reason, data has just one row for particular item which you want to cross-tab and every other point all is fine. Can I just remove the row totals? It's RIDICULOUS!!!
Each item has one value shown, and its total is simply a duplicate. SICK!!!
Loads of row items, loads of column items, loads of summarized items - all is well. Don't want row totals...
Thanks
Life = luck (+/-) and effort (+/-). If you have no luck & make no effort, then you are dead
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 13 May 2009 at 8:13am
If I understand you correctly, in v11 go to the crosstab expert, customized style tab and check "suppress row grand totals" in the lower right hand corner.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum