• 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.

Recent content by Lukas

  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

    Great, I just have one more modification for this - please? I do not understand how to develop this for n-rows and n-columns. Where Person Product Region Sales Date are fixed and in source table you get new dates periodicaly, so number of columns is growing. I have problem understanding MOD...
  3. L

    Transforming data for Pivot analysis

    Hi, I am aware of this great functionality. Let me explain. I have data in this format (example): Person, Product, Region, 1.1.2010, 2.1.2010, 4.1.2010, 7.1.2010 (HEADER) Luka, hammer, Reg1, 234,443,2322,333 (LINE ITEM, Where numbers are Sales on the DATE) Hui, hammer, Reg2...
  4. 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...