Wim Den Haese
Active Member
Joined: Apr 6, 2020
Follow
RE: Different granularity in one pivottable
Hi Mynda, It just seems strange having to calculate a value through a workaround which is already present in the model. I have seen a textbook exam...
3 years ago
Forum
RE: Different granularity in one pivottable
Hi Mynda, Apologies - the file was too big hence it did not upload. I have attached a smaller sample file here. Regards, Wim
3 years ago
Forum
RE: Transposing tables with varying number of rows
Many thanks Catalin I will give both options a try - the second one seems to be the easiest to understand but the first one is something I hadn't t...
3 years ago
Forum
RE: Transposing tables with varying number of rows
Hi Mynda, Apologies - the query must have disappeared from the file when I ran the document inspector. I have added a sample file with the query...
3 years ago
Forum
RE: Transposing tables with varying number of rows
Hi Catalin, I will try and add a sample file, but I first need to scramble the data. I will try and explain what I want to accomplish. The reaso...
3 years ago
Forum