Default filter in a pivot table

Wed, 08 Aug 2012 21:36:25 GMT

Hello, it's me again, I have other problem.

I need to implement a conditional count in a pivot table with 2 dimensions: Month and Recruit/Termination, which is a dimension related to the different types of employee recruitment or termination. Normally, the NumericCount() function will count how many employees were recruited/terminated for each month and each type of recruitment/termination.

But I also need to apply a filter related to certain values of a dimension not shown in the pivot table, e.g. "State", and the allowed cases are State = "A" and State ="B", and I don't want the user to apply the filter by clicking values in a list box.

So the question is. ¿Is it possible to apply a default filter by code? and if so, ¿how can I do it? If I want to sum the results for columns "november" and "december" to create a column "EndYear", how can I do it?

I hope you can help me with this problem, regards!

Re: Default filter in a pivot table

MayilVahanan — Wed, 08 Aug 2012 22:02:06 GMT

Use,

=Count({<State={'A','B'}>}distinct Employee)

=Count({<State={'A','B'}>}Employee)

Re: Default filter in a pivot table

Thu, 09 Aug 2012 15:44:26 GMT

That's exactly that I need, thanks you

topic Re: Default filter in a pivot table in Water Cooler

Default filter in a pivot table

Re: Default filter in a pivot table

Re: Default filter in a pivot table