Error in calculated dimension

[#1]

Dear All,

I am trying to generate a report using chart -> straight table and would like to fitler the data. I have a straight table with all the columns as dimension and expression =1. the straight table gets generated properly but when i am trying to filter the data i am getting error in calculating the dimension".

I have the following data

Qty	Price	Buyer	Seller
2000	2.0	ABC	XYZ
3000	2.2	ABC	PQR
3000	2.0	XYZ	PQR
4000	2.0	ABC	AAA

I have a list box containing all the buyer and seller and would like to filter the above data based on the selection in the list box.

i have the dimension for buyer as

only ({<buyer = {"$(=getfieldselections(Firm))"}> buyer) ... where Firm is the list box used for selection.

Kindly let me know how i can get this data filter...

Thanks and Regards,

Qaiyum

[#2]

Hi,

Sorry, for my previous post, I could not get your point correctly.

You have to use advanced aggregation, you can not use group functions directly in calculated dimensions.

Try this expression, it will work.

=aggr(only({<Buyer={"$(=GetFieldSelections(Firm))"}>} Buyer),Buyer)

Let me know, if any issue.

..

Ashutosh