Chart Inter Record return excluding combination/value

[#1]

When using before,first,above,... it returns combination which are usually hidden

First pivot with a simple expression =SUM(AAA)

Then adding a 2nd expression =Before(Exp1)

Why do I get these extra column/row? Any solution?

[#2]

Hi Nicolas

Before()/After() returns null for all objects except pivot tables. In pivot table it works like Below()/Above() in other charts.

In addition to this Above() by default returns null in first row and Below() returns null on the last row (no row exists before first row and no row exists after last row)

Lukasz

[#3]

Hi Lukasz,

I am not sure to understand completely. I am using a pivot. In my example, why are the first row and first column showing? There is no related data with the expression sum(AAA)

What is the solution?

[#4]

Before in Column A is null because there is no column before A. A is the first column.

[#5]

I do not get you. May be my example is not clear. Can you open the attached qvw?

In the first pivot, column where Test=A is not showing as there  is no record matching with the expression =SUM(AAA)

Now, why after adding a 2nd expression = Before(Exp1), this column get displayed? Same goes for the first row.

How do I keep this hidden? Do I need any set analysis with the Before expression? Is Set Analysis compatible with Before/Above/...?

[#6]

Any solution?

Is there a tweak with Set Analysis or If condition, without any performance impact?

[sunilkumarqv]

I dont understand why you using  =Before(Exp1) instead of that simply change the =(Exp1)  and what you want to achieve?

[#8]

for test = C,

=Before(Exp1) is returning 2000

whereas =Exp1 would return 1500

[sunilkumarqv]

Thats wright such  manner

test = B returning Null Because A = null

test = A before no column so returning  A = null

My  Question is  what you want to understand from that ?and what you want to achieve O/P ie o/p?

[#10]

This is my target:

This is just an example, later I want enhance Expression 2 to compute % growth..