Dear all,
I tried to do the table content the data and showing it as in the picture attached but I couldn't, I don't know why although I have include all the calculations. I have attached the workbook, So please help me in that.
Thanks in advance for your kind support.
Hi Feras Fares
Please see below steps for solutions.
Step 1: For First Sum(0), You need to drag and drop 'SUM([Quarter])','[Quarter%_neg]','[Quarter%_pos]' on text icon.
Step 2: Create two calculated Dimensions which name as below:
Possitive Arrow Quarter
IF [Quarter%_pos]>0 THEN
'▲'
ELSE
''
END
Negative Arrow Quarter
IF [Quarter%_pos]<0 THEN
'▼'
ELSE
''
END
Step 3: Drag and Drop 'Positive Arrow Quarter' and 'Negative Arrow Quarter' on Text Icon.
Step 4: Right click on 'Positive Arrow Quarter' and click on 'Compute Using' -> Click on 'Table (down)'.
Step 5: Right click on 'Negative Arrow Quarter' and click on 'Compute Using' -> Click on 'Table (down)'.
Step 6: Click on Text Icon -> '...' -> Edit Label Dialog box open and arrange dimensions as per below screenshot.
Step 7: Follow Same above steps for Second Sum(0).
Step 8: Final Output as below.
Let me know if you have any issue for above steps.
Please find attached workbook.
