• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. L

    Pivot table grouping + rest

    I need to shov top 20 customers plus rest in a table. I use Pivot with TOP 10 filter to TOP 20 ITEMS. I need to add field with REST values after 20th customer to have full month data. Can I do it with flters and caltculated filds? I am now creating two tables and joining them for final...
  2. L

    Transforming data for Pivot analysis

    Hi, can you help me with some data manipulation: Problem: I have CSV file that is structured as file posted in Visualization Challenge #2. What I want to do: To more easily analyse data Pivot is used, but data needs to be changed in table where daily sales values are not positioned right...