Show unique values in pivot table

[#1]

I have a pivot table showing 'Ideas' at various Statuses (x-axis dimension) by Region (y-axis dimension).

However it is only showing one Idea per region and stage, when I know for some there are multiple Ideas.

My expression is very simple:

=Ideas.Idea.Title

As are my dimensions, which simple list the field name. The are not calculated in any way.

How can i show ALL the ideas at each Status and Region?

[jsingh71]

For color write your expression as per below image:

[morganaaron]

This would only work if all your ideas within the stage/region combination had the same priority. There's no way to do that unless each idea had a unique cell unfortunately.

[#4]

Even for multiple rows or text IN THE SAME CELL?

[Digvijay_Singh]

I don't think you can color text of individual ideas in one cell.But you can color the complete cell by adding condition in the background color(thru '+' sign below the expression). I think this won't work if some of ideas are of high priority in same cell.

Not sure of color differences in same cell.

[Clever_Anjos]

try Concat(distinct Ideas.Idea.Title)

[#7]

That puts them in the same cell Celever.

Unfortunately i need to format each idea cell differently

[Digvijay_Singh]

try Aggr(Only(Ideas),Region,status)

Not sure but this may put each idea in different cell, not sure though..

[#9]

That only shows a combination of Region/Status that has one idea.

If there are multiple ideas for a particular Region/Status it doesn't show that cell/column at all!

[#10]

I'm so close! This is how I need the final table to look, BUT with each idea in a separate cell

In this case, I have simply Concatenated the ideas and inserted a line break

Is there no way this can be done?

[Digvijay_Singh]

I think you need to include all three fields as dimension so that each idea can appear in different line( which you don't want as you said initially to keep the chart short) but if there is no option suggested from others as well, you can think of going with it with a list box of priority, filtering red,orange, green only based on selection.

You can have one value always selected in list box( through list box property) so that chart shows important entries only while launching.