Sum two periods

[sergio0592]

Hi all,

I have data with orders nb associated with two fields :

-period (Day / Night)

-week (Week / Week-end)

In my chart i display orders nb for Day Week (monday to friday and 08:00 to 18:00) and Night / Week-End (Saturday and sunday or night monday to friday).

It works but i have to sum Orders WE with Orders NW. And i wonder if there a way to simplify this with just one Set Analysis line?

Regards

[sunny_talwar · Accepted solution]

May be like this:

=If($(vValue_list)='Day&Week',sum({$<Period={"D"},Week={"W"}>} [Orders nb]),

Sum({$<Period={"N"}, Week={"W"}>+$<Week={"WE"}>} [Orders nb]))

[sergio0592]

I made sum of Set analysis and from now thanks to you i'll make sum inside Set analysis!