Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum({<Channel={"PPC"}>} yourfield)
Sum({<Channel={"PPC"}>} yourfield)
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
Use set analysis which will override the selection of the field
Sum({<Channel={'PPC'}>} FieldName)
Hope it helps