Limit the dimension values in pivot table

vireshkolagimat — Thu, 25 Jan 2018 13:23:01 GMT

Hello All,

I need to show the sales value by CustomerGrp, CustomerName and by agency in a pivot table.

I have around 100+ CustomerGroup and agency and i want to show the sales value only for the selected CustomerGroup and selected Agency.

Any idea how we can achieve the same.

how about creating the calculated dimension like if(match(CustomerGroup, 'Group1', 'Group2')) as CustomerGroup.

Thanks for the suggestion.

Regards,

Viresh

Re: Limit the dimension values in pivot table

kaushiknsolanki — Thu, 25 Jan 2018 13:29:32 GMT

Hi Viresh,

There are couple of ways to do this.

1. Using If statement in dimension (Similar to what you have shown).

2. Adding set analysis and filtering the data.

3. Create a separate field in script to have only required group and then using it as dimension with Suppress null option.

Regards,

Kaushik Solanki