straight table

[denis115]

Hello!

I need help!

I have a table where I have :

prodname

sales_sum

start sales

last sales

and when I select big period of time I need to see in : sales sum (sum of sales in this period)  ,  start sales (sales of first month selected)

and last sales (sales of last month selected)

how can I do this?

Thank you!

[mdmukramali]

Hi,

You can Use Calendar Object.

See here for a video tutorial on just that subject.

Thanks,

Mukram.

[kenphamvn]

Hi

try expression like this

sales_sum: sum(Sales)

start sales: sum({<Month={"=$(=Min(Month))"}>} Sales)

last sales: sum({<Month={"=$(=Max(Month))"}>} Sales)

regards,

[denis115]

there is an error in expression

[tresB]

Could you share your sample qvw?

[HirisH_V7]

Hi,

i hope this three kind of expressions will give you a desired result,

1. Sum({<MonthNum={'$(=Min({<Year={"$(=Min(Year))"}>}MonthNum))'}>}Sales)
2. Sum(Sales)
3. Sum({<MonthNum={'$(=Max({<Year={"$(=Max(Year))"}>}MonthNum))'}>}Sales)

you need to have your date calendar having monthnum column and year as above.

HTH,

PFA,

Hirish

[denis115]

Can I do it with my variabiles?

[HirisH_V7]

Yes! you can ,

But you need to check there are working as expected, By checking them in text box or in straight table itself by hovering on expression(Expression should not be labeled).

[denis115]

test

[HirisH_V7]

* I have made changes in my above post . Please check.