Set analysis

[#1]

How can I restrict the data shown on a straight table by only showing the last 6 weeks of data? I need to retain the data in the file though to display it on another chart in the same file, so it can't be specified in the load.

I have a calculated column, with the formula

PRICE*NOMINAL/100

I tried this

{$<WeeksAgo={">=1<7"}>}PRICE*NOMINAL/100

but i get the error message 'Garbage after expression "$" '

help!

[#2]

Can dimension limits be used for this purpose? If so, how?

[tresesco · Accepted solution]

You missed an angular bracket.

Try like :

Sum ( {$<WeeksAgo={">=1<7"}>}PRICE*NOMINAL/100)

[Anonymous]

There is no expression here.  Try

sum({$<WeeksAgo={">=1<7"}>}PRICE*NOMINAL/100)

[santharubban]

try this

{$<WeeksAgo={'>=1'},WeeksAgo={'<7'}>}PRICE*NOMINAL/100

or

{$<WeeksAgo={">=1"},WeeksAgo={"<7"}>}PRICE*NOMINAL/100

[#6]

Thanks everyone

Where would I be without the community?!