Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have one calculated dimension as below
If(SHEET_ID = 'A.7.z' and match(LINE_NUMBER, '13') and match(Lob_ID, '242') and match(SUB_ID, '5'), 'Non-CB&S Central/ GLM'),
If(SHEET_ID = 'A.7.z' and match(LINE_NUMBER, '13') and match(Lob_ID, '242'), 'All CB&S'
In first line it consider only SUB_ID = 5
In second line it should consider all SUB_ID, but it does not.
If I remove first line than I am getting right amount. What to put in second line so it consider all SUB_ID?
Thanking you all
Clik on advanced editor in the top right corner, so you will be able to attach a file ("attach" is the bottom right corner).
Sorry to ask, I do not see advance editor icon/option. See the screen attached
Thanks
Please, don't worry
Go to the full discussion where our questions/answer are, then reply to a messagge: you will see, as my screenshot shows, (sorry for the italian language...) the advanced editor option.
Thanks for walk with me through
I have attached
Thank you.
I had a similar problem: I think the issue is due to the fact that the sets of data determined by if statement are not disjoint One is a subset of the other.
A question: do you have only these 4 combinations?
LobID 242 & SubID 5 |
LobID 242 & All SubID |
LobID 310 & SubID 4 |
LobID 310 & All SubID |
If yes, you could create a dimension (with an inline table) with these "labels", then, write an expression (with set analysis) with 4 if statement like this:
if(Dimension='LobID 242 & SubID 5', sum({<LobID={242}, SubID={5}>}Amount),
if(Dimension= 'LobID 242 & All SubID', sum({<LobID={242}, SubID=>}Amount) , .....))))
Please, let me know!!
Elena
I have achived by the way you suggested. I applied in SET ANALYSIS, rather than Dimension.
I appreciate your continuous interest and follow up, Thanking you.
Really helpful answer