locked
Analytic chart features RRS feed

  • Question

  • Hi all,

     

    Tanks once again for helping us in the ocean of "unknowns"Smile

    Now I wanted to ask, if there is a possibility to make a chart, showing, ex. Sales by quarters with a Quarter filter, so that when you select ALL, you see all 4 quarters shown, and when you select ex. 1 quarter, you see 3 first months of the year shown?

     

    Skirma

    Wednesday, September 10, 2008 8:43 AM

Answers

  • Yes Skirma...

    You can do that by using Time Intelligence Filter.

     

    Formulae:

     

    (Year).FirstMonth :Month                                                                                   Current Fiscal Year

    (Year).Quarter.FirstMonthSadYear).Quarter.LastMonth Current Year Q1
    (Year).(Quarter+1).FirstMonthSadYear).(Quarter+1).LastMonth                       Current Year Q2
    (Year).(Quarter+2).FirstMonthSadYear).(Quarter+2).LastMonth Current Year Q3
    (Year).(Quarter+3).FirstMonthSadYear).(Quarter+3).LastMonth Current Year Q4

     

    Hope this is what u want..

     

     

    Wednesday, September 10, 2008 10:18 AM

All replies

  • Yes Skirma...

    You can do that by using Time Intelligence Filter.

     

    Formulae:

     

    (Year).FirstMonth :Month                                                                                   Current Fiscal Year

    (Year).Quarter.FirstMonthSadYear).Quarter.LastMonth Current Year Q1
    (Year).(Quarter+1).FirstMonthSadYear).(Quarter+1).LastMonth                       Current Year Q2
    (Year).(Quarter+2).FirstMonthSadYear).(Quarter+2).LastMonth Current Year Q3
    (Year).(Quarter+3).FirstMonthSadYear).(Quarter+3).LastMonth Current Year Q4

     

    Hope this is what u want..

     

     

    Wednesday, September 10, 2008 10:18 AM
  • Yes, Bharti, it really is!! Thank You and have a good daySmile

    Wednesday, September 10, 2008 11:59 AM
  • Ok Skirma..

    mark the post  as anwsered if u got the answer,so that others can easily find..

     

    Regards,

     

    Wednesday, September 10, 2008 12:23 PM