Text box and pivot table expressions

[ajsjoshua]

Hi all,

I am using this expression

=sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {$(=Max(Week_UP))}>}Orders)

which is working fine in text box but its not working in pivot table.

Regards,

Joshua.

[vikasmahajan]

What is a dimension , attached some sample qvw

Vikas

[avinashelite]

Text box doesn't consider the dimension and its totally dependent on your selection , expression but in the Pivot table expression are totally dependent on the dimensions your using . check your pivot table dimensions once

[ajsjoshua]

Hi PFA

[ajsjoshua]

Hi avinashelitevikasmahajan

PFA .

I am getting wromg answers in pivot

[avinashelite]

could you please share the dimensions your using , currently i don't have the QV licence. You could share the snapshots of your dimension and expression 

[ajsjoshua]

Hi

'avinashelite

[avinashelite]

Are you using any accumulation in Pivot table??

[ajsjoshua]

Hi avinashelite

No bro

[er_mohit]

Try this

=sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {"=$(=Max(Week_UP))"}>}Orders)