Multi box Values

[#1]

Hi,

I am using an excel to develop reports.

I have column named 'week_ending _date'.

Values in the column are:

5/6/2011  12:00:00 AM

5/13/2011  12:00:00 AM

2/17/2012  12:00:00 AM

11/30/2012  12:00:00 AM

2/8/2013  12:00:00 AM

So, I have Weekly data from 2011 - 2013     

From this I should create a Multi box Property but the values in the multi box should be-

Current week

Previous week

Current QTD

instead of the values which are there in data.

How do i achieve this? Can any one tell me the steps and query to achieve this?

I have attached the Sample excel.

Thanks in advance.

[Anonymous]

Not saying this is the best solution.....but this will work.

name your original table 't1' and add the following to load script:

Load distinct

max(date) as d1,

date,

rowno() as sortnum

resident t1

group by date

order by date DESC

;

Add this expression to in your chart:

if(sortnum <= 13,sum(TEB))

[#3]

Thank you for the solution.

But I achieved the solution by [sum(if(date>= date(today()-91), TEB))] expression.

Also, Please find the attached image file and excel.

I am having 2 products named X and Z in my excel.

and the values i am using are for the trend line is sum(TEB).

This [sum(if(date>= date(today()-91), TEB))] expression helped me to get the 13 weeks data for sum of both X and Z.

For the same query, I want to display 2 trendlines for X and Z.

How do i get this? Do I have to try with a if condition? (I want to keep this query also [sum(if(date>= date(today()-91), TEB))] in the condition.