Expression

[#1]

HI Experts

I have a sales table, I want to calculate sum(sales) for Current Month and
I am using the following expression to calculate it

=Sum({< DEC_MonthYear=, DEC_Date = {'>=$(=Date(MonthStart(vMaxSalesDate)))<=$(=Date(vMaxSalesDate))'} >} Sales)

But Now i want changed my script and loading

as

Load

date,

sum(Sales)

,

,

From

Now How can I Change the expression

[#2]

can u share qvw?

[anbu1984]

Rename Sum(Sales) to Sales, then you don't need to change your UI expression

Load

date,

sum(Sales) As Sales

,

,

From

[#4]

HI Anbu

Will it work the same

because I am using a dimension Customer Number

I want the sum(sales) against the customer Number

[anbu1984]

Can you post the script

[#6]

Hi Anbu

Here is the data

[anbu1984]

So you want to calculate sum(Sales) from QVD data?

Can you post your script?

Is Sheet1 data different table than QVD?

[#8]

HI Anbu

Please Provide me your emaiID I ll send the QVW to you