Select data that contains certain dimension

[ecabanas]

Hi,

I'm creating a table calculating a gross marging for certain categories, but is it possible to calculate for example the orders that contain Baby category?

Thank's

Eduard

[aarkay29]

Something like this:

sum({<OrderCategory={"Baby"}>}Sales)

[ecabanas]

Hi Aar,

Thank's for your answer, but not it is..your formula is the sum of sales for the category Baby, I have 10 categories.

I want to calculate the total of the basquet for the people who bought something from baby category

Best

Eduard

[aarkay29]

I am not clear on what exactly you want

can you please explain with sample data

[vishsaggi]

What are your dimensions and expressions you are using here?

[ecabanas]

Hi,

I'm using a dimension called category. I sum the revenues of all categories, but all what I want is to see the total basket revenues from the orders that contains baby.

thank's

[vishsaggi]

I am not sure what you mean by Total Basket revenues? Can you share a sample app and expected output please?