Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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())
May be this
If(Category = 'Green' and Mod(Month(SaleDate), 3) = 1, Aggr(Sum(Sales), SaleDate, Category)/Sum(TOTAL <SaleDate> Sales), Null())
Sunny:
Thankx, I also need it to ignore the date selection.
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())