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]

If Total Sales =Sum(Sales)

Then in Set analysis you can write it as

=sum({$<Product_Group=>} Sales)

[#3]

Thanks Sujeet. I don't think Sum(Sales) work because my present measure has this calculation and all the selections are applicable including product group.

I would also like to know how to implement this expression if we have 4-5 selection lists and just to exclude Product Group from total Sales.

Thanks,

MC

[sujeetsingh · Accepted solution]

In any expression if you are going to point as

    {$<FIELD=>}

then the field selection will not have any selection affect in your expression

[sunilkumarqv]

Hi,

  Exclude only  the total sales from Product_group remain same

=sum({$<Product_Group= {*}-Product_Group={'total Sales'}>} Sales)

Hope these is you looking for

[jagan]

Hi,

Try

=sum(TOTAL Sales)

Total will ignore the dimension

Regards,

Jagan.

[sunilkumarqv]

On dimesion LImits Ignore Show Total and show others you will get solution .

[er_mohit]

for total sale column write this

sum(total {1} Sales)

[#9]

Thank you all for your inputs..

Thanks,

MC

[#10]

One last question on this topic.

My list selection is an expression ProductGrpCd &'-' &ProdctGrpName how to replace Product group with this expression in set expression?

When I tried using at it is, it throws an error.

Thanks,MC