Hi Michael Try this. If either one of the two conditions are TRUE then re-order =IF(OR(K3<300,AND(H4<TODAY()+60,O4<1)),"Re-Order","") ...
Hi What do you mean by removing "One"? Can you give a couple of examples of what you have and what you expect the results to be. Sunny
Hi Annamaria You can try using CELL("format",X) where X is the cell to check the format. The formula will return F1 (1 decimal place) and F2 (2...
Hi Gayle From your raw data, the PT looks OK when sliced although I did notice that the Store ID slicer is not connected to PT1. Store ID 2000 a...
Hi Melinda Do let us know if you need further assistant. Sunny
Hi Andy Please refer attachment. You will need to include a button on each sheet. Sunny
After cleaning, you can then create a helper column to group the RECOMMENDATION categories that will help you count them.
Hi Gayle Why don't you post some sample data together with what you have done so far. This will help us to understand your needs better. Sunn...
Hi Melinda Maybe you could do the COUNTIFS on the raw data instead of the PT. The formula will be very long and difficult to read. If you want t...
Hi Amy Thanks for your feedback. Happy to know it is working for you. Sunny
Hi Amy Not sure if your "blank" means a totally blank cell or 0 (or something else). I set it to check for blank cell .i.e. = "" You can chan...
Hi Paul That's great!! Glad to know it is working well for you. Sunny
Hi Paul In cell G3 of the Occupancy sheet enter =VLOOKUP($A3,'REV OCC'!$E:$AW,MATCH(G$2&$A$1,'REV OCC'!$E$7:$AW$7,0),FALSE) No idea if it...
Hi Melinda See if this is what you had in mind. If you set the report to tabular format (easier to see) you can see the subtotals. Just unselect...
Hi Melinda As for the Timeline, you just need to select any cell in your PT and click Pivottable Tools - Analyze - Insert Timeline The Timeline ...