I am stumped goggling this one. It sounds so simple (and it used to be with a standard pivot table), but I cannot figure out how to group items in a dimension so that I can add them together as one unit.
Let's say I have a column called "Pets". The possible values for Pets are: Collie, Great Dane, Poodle, Tabby, Siamese, Persian. In my Pivot Table, I want to see "Dogs" (the sum of Collie, Great Dane, Poodle) and Cats (the sum of Tabby, Siamese, Persian). I used to just create a calculated ITEM that added each category together. I know that is no longer available, so could anyone tell me the DAX-world equivalent to do this? I don't think it is a measure. If it is a calculated column, how do I go about adding it?
Thanks.
[Excel 2010]
Let's say I have a column called "Pets". The possible values for Pets are: Collie, Great Dane, Poodle, Tabby, Siamese, Persian. In my Pivot Table, I want to see "Dogs" (the sum of Collie, Great Dane, Poodle) and Cats (the sum of Tabby, Siamese, Persian). I used to just create a calculated ITEM that added each category together. I know that is no longer available, so could anyone tell me the DAX-world equivalent to do this? I don't think it is a measure. If it is a calculated column, how do I go about adding it?
Thanks.
[Excel 2010]