Select just one field in dimension

[#1]

How do I go about summing just one field within a dimension?

For example, in the dimension "Channel", I have a list of media channels. I'd like to sum up where Channel is just "PPC". How would I do that?

With thanks,

Simon

[Clever_Anjos · Accepted solution]

Sum({<Channel={"PPC"}>} yourfield)

[MayilVahanan]

Hi

Try like this

Sum({<Channel={'PPC'}>} yourfield)

Edit:

Ex:

Sum({<Channel={'PPC'}>} Sales)

If more than two,

Sum({<Channel={'PPC','TCS'}>} Sales)

Hope it helps

[CELAMBARASAN]

Use set analysis which will override the selection of the field

Sum({<Channel={'PPC'}>} FieldName)

Hope it helps