Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Format a Data Type for a Row not a Column

Accepted Solution Solved
Reply
Contributor
Posts: 55
Accepted Solution

Format a Data Type for a Row not a Column

Hi Forum I'm using a List table to display a report that contains text headings in Row 1 & Column 1, the Cells that intersect these headings need to have Formatting applied across the Rows & not the Columns. Is there a way or workaround (coding) to get the individual Rows or certain cells to apply Formatting such as Row 2 would need to be Currency, where Row 3 should be a Percentage etc. I'm finding that I get the formatting applied under the top row headings for the whole Column. I know this is how it should behave but I need to use a List table for appearances sake & I need the Data to be correct in Format. Any suggests ideas all welcome.Thanks

Accepted Solutions
Solution
‎06-01-2017 12:35 AM
Super User
Posts: 3,106

Re: Format a Data Type for a Row not a Column

The only way I can think of doing this would be to create a List Table comprised of only character columns. Within each character column you can format a numeric value however you wish. For example a percentage might look like - " 75.48%" (the quotes are purely to delineate the text but would not show in the report). These character columns most likely would be added outside of VA. You could also keep non-displayed numeric equivalent versions in the data for use in formulas and other reports. 

View solution in original post


All Replies
Solution
‎06-01-2017 12:35 AM
Super User
Posts: 3,106

Re: Format a Data Type for a Row not a Column

The only way I can think of doing this would be to create a List Table comprised of only character columns. Within each character column you can format a numeric value however you wish. For example a percentage might look like - " 75.48%" (the quotes are purely to delineate the text but would not show in the report). These character columns most likely would be added outside of VA. You could also keep non-displayed numeric equivalent versions in the data for use in formulas and other reports. 

Contributor
Posts: 55

Re: Format a Data Type for a Row not a Column

Thanks SASKiwi, I'll give it a try. Cheers
Contributor
Posts: 55

Re: Format a Data Type for a Row not a Column

Thanks SASKiwi, I lked your suggestion & will keep in mind for another project as I decided to create several List tables with just a Heading & 1 row of data each & place them one on top of the other. There's a bit of a waste of space but I get control of the Data format & Display rules this way. Thanks Again !!
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 251 views
  • 1 like
  • 2 in conversation