Hello Meenu, I just need bold only for total field and border should be done as per the above screenshot. I am unable to do it with the above scenario.
Need someone's help to overcome this issue.Any workaround please.
The way you wanted the formatting it quite impossible as per my understanding unless you don't change the structure of the source .
You cannot format any specific value from a dimension like "Total" from Country field. Whenever we apply formatting its applies to all the header/pane/axis of the worksheet.
However, find my approach,
You need to first transpose the data using pivot option.
Then create a field to set the position of your pivot field names (which is your measures). For that I've written a case statement.
//Note: I've excluded "Sales" from Pivoted Field Names and "Total" from Country dimensions to evaluate the expected output.
CASE [Pivot Field Names]
WHEN "Sales1" THEN 1
WHEN "Target" THEN 2
WHEN "Target1" THEN 2
WHEN "Target2" THEN 2
WHEN "BP1" THEN 3
then apply formatting like this
Let us know if this help.
Total & Borders_v10.2.twbx 20.6 KB
Mahfooj, Excellent work around
Thanks for your kind words Glad I could help!