Skip to main content
Topics#Tableau PrepTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Prep
Jun 28, 2018, 6:24 PM

How do I sum measures that start with xxxx?

Hi everyone,

 

I have data that looks like this that is from Smartsheet. Is there an easy way to create a calculated field that sums up all of the columns that start with June, july, etc. instead of typing each one?

 

5 answers
  1. Deepak Rai
    Jun 28, 2018, 6:38 PM

    First you Need to Pivot Your Data. Then Drag Pivot Field Nmaes to Rows and Pivot Field Values to Text Label

    Thanks

    Deepak

Write an answer...
0/9000