Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need help wiriting an expression for a bar chart definition.
I have manged to create a single definition as below, but really struggling to add another selection as I put it.
Currently which works fine
Sum({ <[POH] = {P}>} [Hours])
In english = Sum hours when POH = P
Going forward
Sum({ <[POH] = {P}>} and {<[SITE] = {A}>} [Hours])
In english = Sum hours when POH = P and SITE = A.
Help would be very much appricaited.
Sum({ <[POH] = {P},[SITE] = {A}>} [Hours])
Try This,
Sum({ <[POH] = {P},[SITE] = {A}>} [Hours])
Hope to Help
Sum({ <[POH] = {P},[SITE] = {A}>} [Hours])
Thank you both, I was so close as well.......
Sum({ <[POH] = {P}>} {<[SITE] = {A}>} [Hours]) .
Many thanks rajni.batra and Simon Ijäs