Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a line graph with two cyclic filters; the x axis being time periods cyclic filter and the y axis being business fields cyclic filter.
I have to plot the counts per month as a % of the current counts for the business fields chosen within the cyclic filter.
I am trying to use set analysis and I am restricting the denominator to the latest month.
=
sum({<[%Data Key]={'Market'},$(=concat({1<$Field-={'Field1','Field2'}>} '[' & $Field & ']=',','))>}
[%Volume])/sum({<
[%Data Key]={'Market'},
[%Date Order]={
$(=max([%Date Order]))},
$(=concat({1<$Field-={'Field1','Field2','%Date Order'}>} '[' & $Field & ']=',','))>}
[%Volume])
However my graph is then only displaying the current month.
Any help would be appreciated.
Thanks