Feedback by UserVoice

Ashvini Sharma (Lead Program Manager, Microsoft)

My feedback

  1. 15 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

      Hi Roman,

      I'm having trouble understanding this idea clearly to see whether Kenneth's input (which seem like the best solutions) are overkill or not. Seems like you have a range of cells where several columns together identify a unique product and you want to be able to operate on them as a group - change fonts/colors/summarize, etc.?

      Is it possible for you to describe in more details?

      thanks
      ash

      Ashvini Sharma [Microsoft Excel]

    • 70 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

        hi aikimark1955, it's just a matter of prioritizing what we work on, so getting votes on this item is actually helping us weigh the importance vs. other items..

        Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

        While it's not possible in Pivot Table value fields settings today, Excel 2016 introduced a new MEDIAN function in DAX. Does this help?

      • 25 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          I received a response back from Sam on this that's more looking for supporting Text measures that propogate, where there's only one value for each value in the pivot table. Is this what others are looking for as well?

          thx
          ash

        • 9 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

            Hi Levi,

            Thanks for the response. Since you're familiar with the Table viewer in Power Pivot, wondering how the functionality of the "database" sheet type would be different than that capability. I.e. is the request a matter of hosting that experience as a new sheet tab in Excel? Or would that still be too much?

            thanks
            ash

            Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

            Hi Bill,

            Have you looked at the 'Data Model' and Power Pivot capability of Excel 2013 and later? It's designed to scale to much larger datasets than the grid, and support joins, calculated columns & measures..

            Would love to hear of your experience with it

            thanks
            ash

          • 9 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              Ashvini Sharma (Lead Program Manager, Microsoft) commented  · 

              Sanjib, Data Model in Excel 2013 and beyond is designed to support large number of rows. Have you already tried it out and found it lacking? How so? I'm curious what your scenario is where the number of columns is restricting.
              '

            Feedback and Knowledge Base