Forum Discussion
Importing Excel tab without summing or sorting
Perfect, so once you drop your field in value section (as shown in my screen shot), you will have drop down to choose the summarize method or don't summarize.
If you don't want this field to be summarized by default, you can change it on modelling table, see screen shot below.
- choose modeling tab
- select you field
- on default summarizatio, click drop down arrow next to sum and choose "don't summarize"
here is screen shot for you , although I'm still not clear about your requirement:
Yeah, I'm not at even the stage of pulling the data into a report or tiles, I'm just at the point where I'm pulling it in and doing some ETL.
anyhow, let me know how I can help you further. cheers!
I was able to cobble together a screenshot of what I'm talking about. The behavior in this case is seen in IntroYear frield.
Perfect, so once you drop your field in value section (as shown in my screen shot), you will have drop down to choose the summarize method or don't summarize.
If you don't want this field to be summarized by default, you can change it on modelling table, see screen shot below.
- choose modeling tab
- select you field
- on default summarizatio, click drop down arrow next to sum and choose "don't summarize"