Previous Week

[bharatkishore]

Hi All,

I have a week column from excel and i have  sales and super sales... Now i need show data for previous week.

The formula for calculating is sales/supersales for previous week.

Can you please help me on this.

Thanks,

Bharat

[Anonymous]

if you have week as number in Excel upto current week

you Need this Expression:

sum({<yourweekfield={'$(=max()yourweekfield)'}>}sales)

if you have not only actual year you Need mroe set analysis

[Anil_Babu_Samineni]

Hello,

LOAD

          DateField,

          Autonumber(Weekstart(DateField), 'Week') as WeekDateField,

          ... FROM .....

Expressions Are:

1) =Sum({<WeekDateField = {'$(=Max(WeekDateField)-1)'}>}Sales)

[Anonymous]

sum({<yourweekfield={'$(=max(yourweekfield)-1)'}>}sales)

[bharatkishore]

Hi Linder

Thanks for your reply..

I need to calculate sales/supersales which should display data for last week.. i m displaying in barchart and it should happen without filters.

[Anonymous]

what is your Dimension? weekfield

and your Expression?

and your data from Excel contains data sales/supersales from this year

so you may use my Expression: sum({<yourweekfield={'$(=max(yourweekfield)-1)'}>}sales/supersales)

or you define a calulated Dimension: if (yourweekfield = week(today()-1, yourweekfield) and

Expression sum(sales/supersales)

[bharatkishore]

I have given the following expression:

=sum({<Week={'$(max(Week)-1)'}>}Sales/SuperSales)

but i am getting the value as 0. Can you please let me know if i missed something..

Dimension i have taken as Brand

[Anonymous]

can you give me some figures so i can try a small sample?

[Anonymous]

sorry Little mistake (equal sign was missing before max)

=sum({<Week={'$(=max(Week)-1)'}>}Sales/SuperSales

I defined inline table and defined Week as Dimension and above expression

Sales:
load * Inline [
Week, Sales, Supersales
24, 100, 10
24, 150, 5
25, 200, 10
];

[bharatkishore]

Please find the attached excel.