Show latest load order value

[renjithpl]

HI All,

I have a field called WeekName with values like - Week 1, Week 2, Week 3, Week 4

WeekName is my dimension, sum(Sales) is my expression,

When i select any month, i want to show only the latest week sales in that month in one table, also in another table i want to show previous week sales except latest week.

Any help.?

Renjith

[nstefaniuk]

Hi.

Some pointers:

- build a rank when you load the dimensions to be able to filter these dimensions later with a set analysis

- take a look on function firstsortedvalue.I have not tested but I hope that if no sort weight is specified, the load order is used.

- I think you can use weekname with maxstring and minstring in a set analysis, but it's ugly.