Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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]))
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]))
I made sum of Set analysis and from now thanks to you i'll make sum inside Set analysis!