Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Grand Total Blank

Answered Grand Total Blank

  • Tuesday, April 24, 2012 1:07 AM
     
     
    Sign In to Vote
    0
    I have the following measure:

    =CALCULATE(SUM('Internet Sales'[Sales Amount]),DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),-q,DAY))/q

    Where “q” would be the number of days inputted  by the user. The problem is I am not getting any grand total as a default. The measure executes fine when put in date hierarchy and with other dimensions. However, it does not show a GRAND TOTAL by default. It needs a dimension to show grand total. Alone it is meaningless. I want to show a grand total by default. How can I achieve this. Any help is appreciated.

    Words offer the means to meaning, and for those who will listen, the enunciation of truth - V for Vendetta.

     

All Replies

  • Tuesday, April 24, 2012 6:11 AM
     
     Answered
    Sign In to Vote
    0

    the reason could be, that your Date-Table has values till e.g. 2015 and you only have facts till 2012

    by using LASTDATE() on your Date-Table you will get back 31st Dec 2015 for GRAND TOTAL where you do not have any facts and therefore the SUM is (blank)

    you may use LASTDATE('Internet Sales'[<DateColumn>]) instead

    hth,
    gerhard

    - www.pmOne.com -