Wildcards in Excel - Uses

-

1) Pivot Date Filter - filtering all days of a month


A quick trick of selecting all the days of a month in a Pivot Date Filter. 

In our example, we have the document date field in the filter on the Pivot and the document date has values from 2019 to 2021 and I need to select all the dates in the month of August 2021. 

Just input 8*2021 and all the dates for the month of August 2021 get selected.




2) Pivot Date Filter - Selecting a specific date across all Months & Years


A quick trick of selecting a specific date across all Months & Years.

In our example, we have the document date field in the filter on the Pivot and the document date has values from years 2019 to 2021 and I need to select the 20th of every month from 2019 to 2021. 

Just input */20/* and we have the 20th across all months and years selected.




Comments

Post a Comment

Popular posts from this blog

SAP ABAP - Generating Excel file for downloading or sending over email

-
Creating excel content from data in an internal table?  Getting the following message when opening an excel created out of SAP - "The file you are trying to open, ‘filename.xls’ is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?" Below is the best solution. This solution is based on the approach used by standard SAP to created excel content from ALV. Once any ALV is displayed, you can get the data into excel using the menu bar option LIST -> EXPORT -> SPREADSHEET.  If there are any questions, put them in the comments.  Sample working code: *&---------------------------------------------------------------------* *& Report Y_EXCEL *&---------------------------------------------------------------------* *& *&---------------------------------------------------------------------* REPORT  Y_EXCEL ...
Read more

Get your signature from a paper to word document

-
Image
Follow the below steps to your signature from a physical hard copy onto a word document. Also ensuring that the background matches. Step 1: Put your signature on a piece of paper and take a snap of it with your mobile camera. Below is what you will have    Step 2: Open a word document that would basically have contents of a letter that you are drafting needing your signature on it and paste the signature pic from step 1 in the appropriate location. Step 3:  The next step is to ensure that the background of the signature is changed so that it matches with the rest of the content on the word document. Right-click on the image and select 'Format Picture' Go to the option of 'Picture Corrections' and set the contrast as '100' The end result is the following:
Read more