Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conditional expressions in pivot table changing the view of pivot table

Hello,

maybe can anyone help me I am having a problem with a pivot table. I have conditional view for expresions. There are 3 expresions Sales qty, Buffer, Stock. As you see in the picture 1.

pivot.jpg

When I choose all of them it's ok, when i choose 2 of them it's ok:

2chosen.jpg

but when i choose 1, the pivot table is changing:

1chosen.jpg

Maybe anyone had the same issue?

5 Replies
sudeepkm
Specialist III
Specialist III

can you please mention the condition you applied on the chart expressions.

I think it could be due the condition why it is showing this way. Please post your qvw if possible.

Not applicable
Author

Hi, What is the expression used?

Not applicable
Author

hi, the conditions is:

properties.jpg

where:

condition.jpg

as the Id for sales qty is 1126

Not applicable
Author

Hi, e_stock_quantity_end_auto and the other two below

condition.jpg

Not applicable
Author

I think it could be do Pivot table, because when i choose one expresion, then i have to move the dimension back, to get the previuos result with one expression. I don't know why...

changing.jpg