Help with Filters and Date

[antoniodneto]

Hi guys!

I have two problems.

The first one is: SHEET VS SAÍDA FINANÇAS

I created two list of filter using the script below.

Load * inline [

Dim

ESPECIAL

MASSIVO

SELECT

VAN_GOGH];

Load * inline [

Dim2

QTDE

RISCO

PDD

MBB];

It's ok when I use just one value in Dim, but when no one is select or when I select all, my tables didn't work, only if i choose one value.

How can I solve that?

The second is: (SHEET SAFRAS)

I have a pivot table with dates format in YYYYMM, I have dates since 2011 but I need to filter the max date and your last 25 months.

Follow my app attached.

Tks guys!!

[jwjackso]

On the first problem, try changing SEGMENTO_SIMULE={"$(=GetFieldSelections(Dim))"} to SEGMENTO_SIMULE=P(Dim).

[antoniodneto]

Hi Jerry!! The first problem was resolved... Tks a lot!!

And about the second? Can you help me?

Tks!!!