Forum

Hi Shawn, Change the pivot structure to display the team name, not just the team member. The pivot should look like this: Team Player Cubs ...

Hi Shawn, Your formula is NOT checking the combination of ART and TEAM columns. WorksheetFunction.CountIf(EvalRange, Target.Value) just checks t...

Hi Shawn, The error comes from the fact that you are wrongly using the Disable Resize from UI. Instead of: ' Enable resizing and moving slice...

Yes, it is possible

See image attached, you still have a few ways to customize the pivot using default tools.

Hi Ahmad, Building a data model needs a properly organized data. For example, the budget seems to pe Per Project, not per expense, so repeating ...

Here is a resource that explains what are defined tables: They are special objects that can be easily manipulated from visual basic, the code will r...

Hi Waqas, Try this in B1: =IF(A1>500,15%,IF(A1>=1,13%,0))

The IsLocked function is wrong. Function IsLocked(ByVal iSheetIndex As Integer) As Boolean ' Return true if sheet is protected, false if not ...

Hi Emmanuelle, The reason is that you are using in Month filter a field from Calendar 2, which does NOT have a relationship with per country table....

Hi Ahmad, Custom rows are possible, you can take a look at these posts: Can you create please a sample of the desired result, with normal ex...

Hi Shawn, Much better than images. Use only: =OFFSET(Fruits!$N$10,,,COUNTA(Fruits!$N$10:Fruits!$N$999),1) (without iferror)

By default, the pivot table will create a unique list of items from that column, you don't have to remove duplicates..

Hi Sherry, The layout is not the most inspired one, it will cause problems in finding the last row because of the formulas and colors. Why not u...

Hi Sean, There can be workarounds, but we need to understand first how are you using the results to be able to provide an alternative. Can you d...