Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Nov 18, 2020, 3:35 PM

Percent by cell format issue

Hi,

Is there a way how we can apply the format of fields by cell and not by measure?

Because I would like to apply the percentage format just for some account and for the other accounts I would like to apply the decimal format to the same measure.

I would like that also in the export excel its is taken into account

Thank you

1 answer
  1. YUNKAI KUO
    Dec 2, 2020, 3:45 AM

    Hi,

     

    1. You can consider to create 2 Calculated Fields using IF function to identify which accounts you want to apply. Next, change the display format for each Calculated Field respectively.Hi, You can consider to create 2 Calculated Fields using IF function to identify which accounts you want to apply. Next, change the display format for each Calculated Field respectively.
    2. For the data export, please click Worksheet > Export > Crosstab to Excel from the menu bar, and you can see number in different formats for different segments.

     

    Hope it helps.

    Regards,

Write an answer...
0/9000