This topic contains 2 replies, has 0 voices, and was last updated by michoel 7 years, 11 months ago.

  • Author
    Posts
  • #5063 Score: 0

    Jarrod
    • Contributions: 0
    • Level 1

    On a customer saved search – is it possible to have the Customer status – IE Closed Won, Lost Etc…

    be a horizontal column on the X axis of a search while having the name be the Y axis?

    In other words – can all the statusus be its own unique column(s)?
    This is a cached copy. Click here to see the original post.

  • #5064 Score: 0

    torin@aminian.com
    • Contributions: 0
    • Level 1

    I wouldn’t have the customer name be it’s own column because that would require a formula for every customer. I would enter a formula (text) in the results for each status you would like to see. For example use the formula CASE WHEN {status} = ‘CUSTOMER-Closed Won’ Then ‘Customer-Closed Won’ ELSE NULL END.

  • #5065 Score: 0

    michoel
    • Contributions: 0
    • Level 1

    You could also look into the Pivot Reports SuiteApp. It has many limitations but may do what you need.

    https://system.netsuite.com/app/help…n_N711412.html

You must be logged in to reply to this topic.