I'm new to using PowerPivot but very proficient in Pivot Tables. I've imported data from a CSV file, all the whole data set came in as TEXT columns. I then set the Data Types to Decimal, Whole Numbers, Dates, etc and I also set the formats respectively.
However, when I finally get to the subset...
Thought... Can you create a separate selection box where the user would 1st chooses 'ALL' or "By Country" (I'd default to 'By Country')... then you could enhance your complex formula with an If statement (then refer to that selection} = "ALL" then use a wildcard or nothing "" (whatever you would...
Hello All,
I'm Patrick from the USA and I'm an advanced Excel User with spreadsheet skills dating back through VisiCalc, Lotus, Excel. I work with IT and the End Users and I need to keep things simple. I'm not a VBA Pro but I take extreme advantage of Excels formulas etc. I look forward to our...