Hello Richard, Riny's solution should help. If you are still having issues, please paste a screenshot of your Pivot Table so we can best help yo...
Hey Edward, Unfortunately this cannot be created inside a Calculated Field or Item, as its limited what formulas it can perform. What you can do...
Yes you can use a # to precede a Calculated Item, that way you can distinguish the calculation as being a Calculated Item. Thanks, John
Hey Seok Li, For this filter you will need to click on the Item Description filter/drop-down in the Pivot Table and deselect the items that contain...
Hey Seok Li, Great question! You will need to right click anywhere on your Pivot Table and select: Pivot Table Options Then go to the tab: To...
Hey Chao, You may be using the space bar for another Field, that is why you are getting the error message. Try putting in 2 spaces or even a cha...
Hey Chao, The various Grand Totals cannot change their names. By default, they are named: Sum, Count, Average, Max, Min. Let me know if this ...
Hey Jeff, You need to put the Patient Name or Diagnosis in the Values Area, this will give you a Count of these occurrences. Then put the Date F...
Hey Thomas, A Calculated Field is a calculation based on your Fields or Column Headers. A Calculated Item is a calculation based on your Field's...
Hey Bankim, Can you please attach a sample workbook as it will be easier to fix your issue that way. Thanks, John
Hey Taviwan, I did this to show that you can use other functions within the GETPIVOTDATA formula. This will come in handy when you create an ad-...
Hey Kevin, Can you please provide me with 2 workbooks with the 2 different results that you want to show, by way of highlighting the Pivot Table. ...
Hey Mike, Yes you can! Hover above a column name for the Actuals and when you see the arrow, left mouse click click and this will select all the...
Hello Mike, Please go to tutorial: 10.10 Use a formula to determine which cells to format. I explain how you can do this in this tutorial! Le...
Hello Anahita, You can also highlight all the items within the first group and press the CTRL key and select the item from the second group. The...