Do I have to use Set Analysis For this Req?

[#1]

Hello All,

Could you please let me know how to achieve following requirement:

My Document has following objects on it:

2 List boxes :

1-Product Group

2-State

Chart List With:

If user selects any Product Group I have to see the sales of that product group in sales column where as total sales of all the product groups irrespective of product Group selected for that state in the "Total Sales" column.

In simple terms Product Group selection shouldn't be applied to "Total Sales" column. How to write an expression to achieve this.

Product Group	State	Sales	Total Sales
PG1	ST1	1000	3000
PG1	ST2	2000	3000

Thanks,

MC

[sujeetsingh]

Try if statement in spite of Set analysis for this list box

[#3]

HI Sujeet,

I don't have set analysis in List box, I have set analysis expression in chart list(straight table).

One of the list box has an expression ProductGrpCd &'-' &ProdctGrpName and I have to use the same in Chart list to achieve the above requirement.

Sorry If I am not clear enough, happy to provide more details.

P.S for time being I pushed this calculation into load statement and used as single filed and it worked as I expected.

Thanks,

MC