Dates as expression in a straight table

[t_hylander]

Hi,

Is there a way to make a table look like this;

I want the dates to be added dynamically depending on what period I have selected. The above is made with set-analysis

sum({1<%SamplingDate={'2017-03-14'}>} Resultat)

Think Ive seen it before but couldnt find it when I searched.

Regards

Tomas

[vinieme12 · Accepted solution]

use a Pivot table instead

with Analys and SamplingDate as dimensions and then drag and drop SamplingDate field to the column headers over the expression

[t_hylander]

Yes, pivot-table ofcourse.

Thanks!