Linechart Display by Qtr Only

[gerrycastellino]

I need to get this line chart to display the beginning quarter dates only, and ignoring any selection on the

date in the list box.

see attached qvw file.

I would want to see the following %'s:

9.09%

50%

95.89%

3.85%

THankx !

Gerry.

[sunny_talwar]

May be this

If(Category = 'Green' and Mod(Month(SaleDate), 3) = 1, Aggr(Sum(Sales), SaleDate, Category)/Sum(TOTAL <SaleDate> Sales), Null())

[gerrycastellino]

Sunny:

Thankx,  I also need it to ignore the date selection.

[sunny_talwar · Accepted solution]

Try this

If(Only({<SaleDate>}Category) = 'Green' and Mod(Month(Only({<SaleDate>}SaleDate)), 3) = 1, Only({<SaleDate>} Aggr(Sum({<SaleDate>}Sales), SaleDate, Category))/Sum({<SaleDate>} TOTAL <SaleDate> Sales), Null())