I have searched the forum but couldn't find an answer to my question maybe you can help me out:
I have loaded a database table and one of the fields i'm loading contains values like Books, EMail, Newspapers:
MyValue:
Books,
EMail,
Newspapers
Now i want to count the sales for each of the different Books, EMail, Newspapers but i don't want to use an if statement in my chart like:
If(MyValue='Books', count(sales))
I need it dynamically! In case i will have assigned a new MyValue like Magazines the sales should be automatically counted for this new value and shown.
Hope my question is clear. In case you have any questions please let me know.
You can use MyValue as dimension and your expression will simple be Sum(Sales), this value vill be automatically splitted into all the values of your MyValue field.