Filtering two pivot tables with same selection list

[#1]

Hello

First at all, excuse my english.

I have a table of vendors, every vendor have a hired date (given by field fingdt) and not all vendors have a exit date (given by field fcxldt). I need to show how many vendors were hired and how many are not with us anymore in a specific year and month. I couldn't find a way to handle both countings in the same pivot table, so my first solution was create two pivot tables, first one (REGISTRO DE ALTAS) shows all hired vendors and the second one (REGISTRO DE BAJAS) will count all fired or resigned vendors. Without any kind of filter all my information is correct but I need to select a period or a ending month (ex. Sept, 2010) and get an acumulative count (an historic increase and decrease personnel). Using a selection list based on FINGDT my first pivot table is filtered correctly but the second one is not taking the current selection.

Also I tried to create a new field (YEAR-MONTH) and use it as dimension with set analysis formula (YEARMONTHCXL <= YEARMONTHING) without succesful.

I really appreciate any suggestion about how to create an acumulative count in both pivot tables using the same selection list or a way to handle both countings in a same pivot table. Maybe with the attached example my requirement will be more explicit.

Thanks in advanced for your help.

[Miguel_Angel_Baeyens]

Hi,

I'd recommend you to take a look a this file. What I've done is to use a master calendar and two variables to set the starting and end date for the desired period, so the values displayed in the chart correspond to this range.

Hope that helps.

Un saludo.