Explain the difference

[eromiyasimon]

Explain the difference between these two expression

sum(Sales)

vs

sum({<[Vendor Name]=,[Dept Name]=>}Sales)

[HirisH_V7]

There the selections for [Vendor Name]=,[Dept Name]  will not reflect the chart or report.If you use that expression.

For restricting the selections for some particular fields, we will include them in the set analysis expressions.Like above.

[Anil_Babu_Samineni]

There is no diff for these, Second one is only for Filter / Sorting for specific

Assume, If you used these 2 expression it won't effect. And if you can go and use filter like below and then check. that is the case they were sort to filter for specific Vendor

sum({<[Vendor Name]={'MagnaInfotech'},[Dept Name]=>}Sales)

[kumarkp412 · Accepted solution]

Hi Simon,

In the first expression, it will give the sum of sales and also it gives the result with a respective selection also.

i.e for supposing you are the sum sales in pivot table using the first expression.when you make a selection on the filter Vendor Name and DeptName. Based on the selection it will display the values on the table.

In the second expression, it will give the sum of sales and also it won't filter the data when you make a selection on vendor name and DeptName.

i.e for supposing you are the sum sales in pivot table using the first expression.when you make a selection on the filter Vendor Name and DeptName. It will disable the selection of the filter and shows the sum of sales of the all.

Thanks

Kumar