Set Analysis in Dimension - Date & Previous Date

[Anonymous]

Hello

For each Date selected (DateID), I have a selection of Stocks (StockID) which I use as a dimension for a chart.
I would like to have not only the StockID for the selected date, but also the ones for the previous DateID.

I think I should use set analysis, but not sure how to do this in a Dimension...

Many thanks and regards

[#2]

Hi Zadig,

It may help you.

The general syntax for showing privious month and year with selcted month and year is

ex:-  sum({$<YearID+={$(=MAX(Year)-1)}>}Sales)  ->It will give you the sum of sales for selected year and its previous year ;  You can use it for month instead of year

In your case:

count({$<DateID+={$(=MAX(DateID)-1)}>}StockID)