« previous next »
Pages: 1 [2]

Author Topic: Issue with hiding null totals in subtotal & grantotal crosstab  (Read 446 times)

Offline krishdw85

  • Full Member
  • ***
  • Posts: 49
  • Forum Citizenship: +0/-4
Re: Issue with hiding null totals in subtotal & grantotal crosstab
« Reply #15 on: 16 Jan 2012 02:57:26 am »
Using a single query in relational db , its impossible to hide nulls in totaling.
I did it finally through UNION.
Logged

Offline krishdw85

  • Full Member
  • ***
  • Posts: 49
  • Forum Citizenship: +0/-4
Re: Issue with hiding null totals in subtotal & grantotal crosstab
« Reply #16 on: 17 Jan 2012 02:02:10 am »
Simple way to handle null values in crosstab is::::


filter ([LOB],[LOB]<>'null')

so that while totaling  , we cant see null value in totalling.
Logged

Online blom0344

  • BI Architect
  • Global Moderator
  • Statesman
  • *****
  • Posts: 1,747
  • Forum Citizenship: +60/-2
  • Assess what you need instead of what you want
    • Reasult b.v.
Re: Issue with hiding null totals in subtotal & grantotal crosstab
« Reply #17 on: 17 Jan 2012 05:34:11 am »
 :o  :o
This is confusing. You mention that you sorted the problem through the defined queries?  In what context should we read your last post?
Logged
Oracle9i,DB2/AS400/Busobj 6.5/Powercenter7/Cognos8 /
SSIS 2005 / SQL SERVER 2005 /PowerDesigner 12.5/15
Pages: 1 [2]
« previous next »