Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

HI I AM NEW HERE

I AM USING COMBO CHAT HAVE A SALE AND YEAR AND CATEGORIES I WANT TO SHOW MEMBER OF CATEGORIES THAT IS MEN's Clothes and Baby Clothes, Men's Clothes  is content line another one baby clothes should change what's the solution

i am giving expression as : 1.sum({<Category={"Men's Clothes"}>}sales)

                                         2.sum({<Category={"Baby Clothes"}>}sales)

this expression is right or wrog

thanks......

2 Replies
amit_saini
Master III
Master III

right

You can also do this way based on current selection:

Ex: sum({$ <Category={"Men's Clothes"} sales)

Thanks,

AS

amit_saini
Master III
Master III

Also this will help u:

Sum({Book1} [Sales]) : sales of the selection of Book1

Sum({Group1} [Sales]) : sales of the Alternate State Group1 (the syntax is identical)

Sum({1} [Sales]) : sum of everything (All dimensions are completly reset to All)

Sum({$} [Sales]) : sum of the current selection (= sum([Sales])

Thanks,
AS