Who has experience to eliminate the records with total euqal 0 in pivottable? This is a requirement our customers requested because this feature is avaialbe in cognos report.
My pivot table is against a tabular cube. (Excel 2013+SQL2012 Tabular)
SchoolName CostA CostB GrandTotal
AAa 10 0 10
BBB 0 0
CCC 10 10 20
They do expect not to show the reord of "BBB" because the grandtotal is 0. Any idea on this?
You could apply a value filter by right-clicking "BBB", selecting Filter -> Value Filter...
Then select "Show items for which Sum of CostA is greater than 0".
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?