Pie Visualization Percentages not Updating with Prompt Selection

[pacificbeavs]

I am using Cognos Analytics 11.0.11.

I have a pie visualization that shows percentages of sales for three categories (e.g. golf ($70), soccer ($20), baseball ($10), therefore 70%, 20% and 10%.    I have a filter at the top of the page that allows you to filter by region.  When you select a region, it displays the percentages as a total of all regions, and not of the region selected. 

For example, if the Northwest region makes up 50% of the sales, then the percentages of products will be out of 50%, and not out of 100%, even though I'd like to see the Northwest region's sales out of 100%.  If I use "for region" in the data item then it's accurate by region, however when showing all regions it displays the pies out of 300%.

Any ideas on how to address this?  Hopefully my description is clear...

My idea right now is a data deck which filters by region, which will work, however I'd like to figure out a different way.

[pacificbeavs]

Any ideas??  The only solution I can think of that would work is a separate deck for each visualization that I want, however based on my report this would mean 16+ decks, so I'm not going to proceed with that method due to the upkeep that would be required, and room for error.

[rteruyas]

Are you still struggling with your report?
I cannot know for sure what you might be missing, but here are some suggestions:

- Check that the measure you show in your pie shows % for region (and not % for report)
- Make sure you added your region as extra category in the pie chart
- Make sure you're not missing any "Interactive Behavior" (set filter based on the region chosen) for the pie

Anyway, I created a small example if none of the above works
This is how it looks: http://imgur.com/a/ww5dt0s

I've attached the report specification.
I used test data, feel free to test it in the public test environment (https://ibmcaoctrial.bi.ibmcloud.com/bi/?perspective=home)

Good luck!

[pacificbeavs]

Are you still struggling with your report?
I cannot know for sure what you might be missing, but here are some suggestions:

- Check that the measure you show in your pie shows % for region (and not % for report)
- Make sure you added your region as extra category in the pie chart
- Make sure you're not missing any "Interactive Behavior" (set filter based on the region chosen) for the pie

Anyway, I created a small example if none of the above works
This is how it looks: http://imgur.com/a/ww5dt0s

I've attached the report specification.
I used test data, feel free to test it in the public test environment (https://ibmcaoctrial.bi.ibmcloud.com/bi/?perspective=home)

Good luck!

Thanks for the info.  I didn't realize that there was a test environment out there, so that's really cool!  I ran your report, and the percentages in the pie upon initially running it add up to way more than 100%, and then they add up to 100% once filtered for country.  I was able to get to that point as well, however I am trying to make sure they add up to 100% when looking at all, and 100% when looking by country.

I think I may do a deck, or change how/what information I'm displaying.