Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have below sample data and i need to make certain rows bold based on the row dimension description.
Dimension | Sales1 | Sales2 |
---|---|---|
laptop | 2 | 7 |
Printer | 6 | 4 |
Desktop | 2 | 3 |
Total | 10 | 14 |
If dimension is Printer, then i need that Printer row should be highlighted in bold. and also the total row should be in bold.
Kindly let me know if we can achieve this.
Regards,
Viresh
Go to Dimension Tab
Click on + Sign of Dimension
Text Format
Write below
IF(Dimension= 'Printer','<b>')
Isn't the Total row already bold? I thought I remember seeing it bold
Go to Dimension Tab
Click on + Sign of Dimension
In Text Format put below expression
IF(Dimension= 'Printer','<b>')
Sames expression you need to write in both sales1 and sales2 expression Text format
Seems like it
Straight table
Pivot table
Oye Manish ka copy paste karta hai
Ha to itna type karte kon bethega.. or extra bhi dala he na.
yeh hua na honest chor
Imandari hi to humari pehchan he
Hey, thanks it is working. How to compare the multiple line items in the same expression.
I tried the below expression but not getting the result as expected.
IF(Dimension= Match(Dimension,'Printers','laptop'),'<b>')
let me know if this can be possible.
Regards,
viresh