Expressions for different Bar groups date filter

[Anonymous]

Hi,

     We have a bar chart and these bars are computed dynamically. Like

      if some one selects year then these bars are daily,

      if 3 years have been selected then each bar should be computed for monthly.

     Incase of 5 years each bar should represent quarterly.

    Dimensions :

          1.Date

          2.Month

          3.Quarter

          4.MonthEndDate

          5.QuarterEndDate

     Fact:

        Accumulated Value

In this case i might not be able to use sum(accumulated assets)  because bar groups are different.Monthly and quarterly  bars need to display MonthEndDate's Accumulated Value, Quarter Ends Accumulated value  respectively.

Here is the code I am using not working correctly:

Dimenions:

=IF(Date>=vStartDate

     AND Date<=vEndDate

     AND Date-vStartDate<366

     , DAY(Date)&'/'&LEFT(MONTH(datec),3)&'/'&RIGHT(calendar_year,2),

      IF(datec >=vStartDate

        AND datec<=vEndDate

      AND vEndDate-vStartDate<1860

      AND vEndDate-vStartDate>366

      ,LEFT(MonthName(month_end_buesiness_date),3)&' '& RIGHT(MonthName(MonthEndDate),2),

      IF(datec >=vStartDate

        AND datec<=vEndDate

      ,RIGHT(year(QuarterEndDate),2)&' '&calendar_qtr)))

Fact:

=IF(vEndDate-vStartDate<366

     ,SUM(Accumulated Value,)

               IF(ndDate-vStartDate<1830

                         AND ndDate-vStartDate>366

                         ,<MonthEndDate's Accumulated Value >,

     <QuarterEndDate's Accumulated Value >)

Please let me know any better approach.

Thanks

Dasu.G

[Anonymous]

Hi ,

      Find the attached QVW file. Behavior we are looking for is that when some one clicks on 2 YR then X axis should have monthly bars(working) and expression should be retreived the Accumulated Value for the month end days value only not sum of entire month.

Thanks

Dasu.G

[Anonymous]

Any thoughts on this?.Can this be achievable to show only month end data in the monthly bar?