Grouping of expressions in bar chart

[#1]

Dear All,

In a bar chart,

I have used the expressions :

For sale:

1.

=sum({<@_Date={">=$(vFinStartDateCY)<=$(vMonthEndCY)"},@_Month=,@_FinQuarter=,@_FinFullYear=>} #_NETAMOUNT)/

100000

this will return the YTD sales for current month

2.

=sum({<@_Date={">=$(vFinStartDatePY)<=$(vMonthEndPY)"},@_Month=,@_FinQuarter=,@_FinFullYear=>} #_NETAMOUNT)/

100000

this will return the YTd sales for Previous year current month

and in this way for measure Qty another 2 expressions are

1.=sum({<@_Date={">=$(vFinStartDateCY)<=$(vMonthEndCY)"},@_Month=,@_FinQuarter=,@_FinFullYear=>} #_QTY)/100000

2.=sum({<@_Date={">=$(vFinStartDatePY)<=$(vMonthEndPY)"},@_Month=,@_FinQuarter=,@_FinFullYear=>}#_QTY)

/100000

the same way another 2expressions for Cost amounts.....

I want cyclic group expression in a way when I will clikc on sales then the sales related 2expression will be displayed....and when I will clik on Qty then only Qty related 2expressions will be displayed and so on......

Please help me....thanks in advance,,,

Regards,

Debasmita Mitra

[tresesco]

Not quite clear though, you can have multiple expression groups using the group button in the expression tab. Otherwise, you might consider using conditional expression as well.

[#3]

I have used grouping of expressions for single expressions before.But how to use them for multiple expressions..i.e-

For sales

2expressions

For margin

2 Expressions

For qty 2expressions

I want to implement cyclic group for sales,margin,qty

How to do so?