Pivot table problem

[#1]

Hi all,

I've a problem with a pivot table. I've two variables (sales and salesLY), one for the sales of current selection and other for the sales of the last year (year selected - 1). With this data, i extract the variation of sales (formula: (sales-salesLY) / salesLY).

The data is correct but in the table, when i apply the filter 'oct-2010', it show 'oct-2010' and 'oct-2009'. What can i do to not have 'oct-2009' in the table? If i remove the variation column, 'oct-2009' does not appear.

Sales: Sum({<CONCEPTO={8600}>} Value)

Sales LY: Sum({<YEAR={$(=YEAR-1)},CONCEPTO={8600}>} Value)

Thanks!

P.D. Excuse my bad english, 😞

[#2]

do you want to show only de column with the formula?

[#3]

Hi Raul,

Thanks for your interest. I want to show the column with the sales amount and the column with the variation.

Here's a snapshot of the pivot table i've now. As you can see, i've filtered year=2010 but there's a row with the data for year=2009.

[#4]

I think it is very reasonable this column is in your Pivot. What you want to achieve is not logical.

Ik you select Year 2009 the column will contain the result for 2008, because you have your variable to year-1

so you have to look again what you want to achieve !

[martinpohl]

Hello,

your formula is

Sales LY: Sum({<YEAR={$(=YEAR-1)},CONCEPTO={8600}>} Value)

YEAR=YEAR-1 so if you select 2010 you calculate (2010-1)=2009

Or am I wrong?

Regards

[#6]

Thanks for your answer Jochem & wise man.

Jochem:

What i want to achieve is, for a selected year, the sales by months (for the selected year, not the selected year and last year) and the growth over the same period last year.

wise man:

You're right, i've to calculate the sales of the last year to see the variation.

Thanks again.