Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can u share qvw?
Rename Sum(Sales) to Sales, then you don't need to change your UI expression
Load
date,
sum(Sales) As Sales
,
,
From
HI Anbu
Will it work the same
because I am using a dimension Customer Number
I want the sum(sales) against the customer Number
Can you post the script
Hi Anbu
Here is the data
So you want to calculate sum(Sales) from QVD data?
Can you post your script?
Is Sheet1 data different table than QVD?
HI Anbu
Please Provide me your emaiID I ll send the QVW to you