Issue in Building A Trendy Chart

[vishnumusani]

HI All,

We would like to display only those Country and specific issue which is repeatedly happening over a specified period of time and Cost occurred for the same as a Trendy Chart. Could someone please guide me how to do the same.

I am attaching a sample file along with required data as a bar chart in pivot table.

Thanks,

MVR

[ogautier62]

Hi,

I hope it is the expected result :

replace dimension Issue by :

if(aggr(nodistinct count(distinct Period), Country,Issue)=count(total distinct Period),Issue)

regards

[trdandamudi]

See the attached and hope this helps: