how to rearrange months in a pivot table

Right click the pivot table, uncheck Subtotal " Fiscal Month": 4. Did you use the same data from the first column just changed the format or did you enter the data in the third column as mmm-dd. Add a Total Row Below Query Pivot Report in Google Sheets. I have a pivot table with the last 5 months in columns. The pivot table now displays the transactions grouped by month ' Apr, May, Jun. EXTRA TIP: You can click inside a cell e.g. … In this pivot table, we have the Product field in the Row Labels area and Region in Column labels … Yeah, I tried that but it won't allow me because Jan is the filtering column (it has the little down arrow for filtering). Advantage of slicers over pivot table filter, it can be connected to multiple pivot tables and pivot charts. In the blue table below, I have listed out the order of how I want the buttons to be laid out reading left to right, moving downward. Case 2: Pivot Table report based on Power Pivot data. Since we want to show the closing price for each weekday, we use Excel’s WEEKDAY() function to convert the date in column A into days of the week. Comments. What I'm going to do for each subsequent answer and question is to answer it using pd.DataFrame.pivot_table. Look at the following pivot table, now I want to sort the regions with this order: East, West, South then North as show as below screenshot. To get the final layout results that you want, you can add, rearrange, and remove fields by using the PivotTable Field List. Because if I omit January, the other months appeared in the proper order. You could try to drag the columns around? Thankfully the pivot table and pivot chart have the dates in the correct order despite the stupidity of the slicer. Click the Insert tab. The first is to click the Options drop down on the Options tab in the Pivot Table Tools group. Build a pivot table with Sales Date in the row area and Sales Amount in the values area, similar to … Creating a Pivot Table. I actually got quite good at them quickly too. The sorting order is alphabetical. The default is "manual", which is what you want selected. Click inside the pivot table. Use a 'custom sort list' and then apply it to your pivot table field. Pivot tables has the one of the most useful features to group the items which is can be used on items of row label or column label. Could the US military legally refuse to follow a legal, but unethical order? Conclusion. Go to the Power Pivot sheet. The zipped file is in xlsm format, and contains macros that let you show a specific fiscal year in one of the pivot tables. There are other guidelines to follow too, when setting up the source data for an Excel pivot table. Anyone with karma >75 is welcome to improve it. In pivot table, we can easily sort these regions alphabetically in ascending or descending order. site design / logo © 2021 Stack Exchange Inc; user contributions licensed under cc by-sa. What would make a plant's leaves razor-sharp? 1. To save time when building, formatting and modifying your pivot tables, use the tools in my Pivot Power Premium add-in. We will click on the pivot table, select the Analyze tab in the Pivot Table Tools, and click Insert Timeline; Figure 7- Insert Timeline. If you don’t want to sort by label or by value, you can sort the table manually, by dragging items around. The simple spreadsheet has a column for the date and another column for the mileage. If you want to remove them then go to –Pivot Table Tools > Analyze > Disable Field … Please refer to the screenshot below. 1. This happens automatically in regular Pivot Table. So, the date will be not be grouped automatically now when you drag the date field to an area in the pivot table. Are there any alternatives to the handshake worldwide? Enable macros when you open the file, if you want to test that macro. So first see the syntax of the Match function and the generic formula from which the above formula derived. if so, you can reorder them by using the field list values pane, by placing the measures in the new order you need. Why didn't the Romulans retreat in DS9 episode "The Die Is Cast"? Changing the sort order. Was there ever any actual Spaceballs merchandise? Pivot tables are utilize to summarize, sort, rearrange, group, check, aggregate, or standard record stored in a database. Select any cell within a table and go to Insert/Pivot Table. Select range A1:C16, then click Insert->PivotTable, choose existing worksheet, locate pivot table in E1, then click OK. #3 Verify that after clicking OK, PivotTable Fields settings pops up. You have successfully manually sorted your Pivot Table! … Drag Labels to New Position. Select Salesperson in the Select Field box from the dropdown list. Sort Z to A. For example will be used the following table: First, you have to create a pivot table by choosing the rows, columns and values: Created pivot table should look like this: Right now I show columns named A, B, C, and Grand Total. That is sorting the columns by the Grand Total – How to Sort Pivot Table Grand Total Columns in Google Sheets. In the Pivot Table properties, Under the sort tab: Select the column which u need to sort,Enable the expression option and put the date field. These tables can bend and turn your data to squeeze out just the information you want to know. This data is then used in a pivot table. Select any cell within a table and go to Insert/Pivot Table. How to convert dates into months/ quarters/ years in pivot table. your coworkers to find and share information. Asking for help, clarification, or responding to other answers. Why is this a correct sentence: "Iūlius nōn sōlus, sed cum magnā familiā habitat"? Why is my child so scared of strangers? I forgot to say one thing! With this 3-column Excel table, it will be easy to create a flexible pivot table, and focus of specific items or months. To get the sample file to sort by fiscal month in a Pivot table, go to the Fiscal Year in Pivot Table page on my Contextures website. Mismatch between my puzzle rating and game rating on chess.com. calc. The Field list will appear. Group by dates; Group by numbers; 1. The issue I have is the order of the year and month in the column heading. Included PivotTable creation in the video to assist others who come across your question. See how to stop pivot table date grouping in the latest versions of Excel, and a couple of workarounds for Excel 2016. How to rearrange the data for a Pivot Table – A must read trick; Add Calculated Fields inside a Pivot Table; Take a free Pivot Table and Sales Dashboard Course . The data table contains daily closing prices spread across various months. Want to rearrange months in a Pivot Table I have a year's worth of data broken down by months. edit retag flag offensive close merge delete. This type of data is often captured by the day. How do I pivot df such that the col values are columns, row values are the index, mean of val0 are the values, and missing values are 0? To display more pivot table rows side by side, you need to turn on the Classic PivotTable layout and modify Field settings. The following sorting options are displayed − 1. Contents. This topic describes how to create pivot tables and efficiently analyze data using pivot tables. I wish I am kidding when I tell you that at least 25 out of the 35 question assessment were on basic formatting, conditional formatting, print settings, and … More Sort Options. If the pivot table isn't properly sorting your row labels, you can bully it around to do what you want. About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new … It sounds like you are sorting by month not date. Only problem is that it is based on a fiscal year where the first month is July and the last month is June. Yeah, I'm pretty sure it is. 2. To learn more, see our tips on writing great answers. How do I rearrange the data columns in a pivot table? Figure 7- Grouping Dialog box . Because the original data, with 12 columns for months, looks almost like a completed pivot table, we want to "unpivot" the data, or "normalize" it. It gives you the option to manually move any of the months one at a time to any location in that column of the pivot table. By using our Services or clicking I agree, you agree to our use of cookies. At the moment it is listed Jan - Dec, but I need it to be Apr - Mar so I have a total mileage for each month from the start … Note, you can’t connect a slicer to a table and pivot table. You can sort the data in the above PivotTable on Fields that are in Rows or Columns – Region, Salesperson and Month. How do airplanes maintain separation over large bodies of water? Step 4: After the pivot table is inserted, then go to the “Analyse tab” that will be present only if the pivot table is selected. Click OK to Step 5: From the “Analyze tab,” choose the option of “Fields, Items & Sets” and select the “Calculated fields” of the Pivot Table. Month order column headings in pivot tables. As you’ve seen previously, both fields are sorted in alphabetical order by default. I have a table with year to date months, open PO's, & budget numbers, but I'd like to change the order in which they show up in the pivot table. We will select Date and drag the scroll bar to choose the specific period we want; Figure 8 – Insert a timeline. I can't seem to get excel to allow me to do that. How do I get months to display in the correct order (Jan, Feb, Mar etc)? If you click the column heading you want to move and then hover over the edge of the cell and click/hold. Does a hash function necessarily need to allow arbitrary length input? Is there any way to do this in excel with a Pivot table/ chart? asked 2018-03-21 17:57:31 +0100. Thanks again. How to pull back an email that has already been sent? I have only one field in Columns, called "Type", and there are six different types (therefore, six columns). To return a pivot table to it’s original sort order at any time, just sort the field alphabetically again. When you add a date field to your Pivot Table, Excel automatically groups the dates into a hierarchy, such as years and months. Pivot Table. Is it possible to force Excel recognize UTF-8 CSV files automatically? The easiest way to move a field is just to drag it from one area to another. There should now be two worksheets ' pivot and master. The data table contains daily closing prices spread across various months. How can I randomly replace only a few words (not all) in Microsoft Word? Is there any way to do this in excel with a Pivot table/ chart? Slicer And Timeline Move And Size With Cells. Change the name of the worksheet from sheet1 to pivot (double left click on the worksheet tab at the bottom). Let’s look at an example of a Pivot Table we have set up with the month as our rows. This will automatically reorder the pivot table columns to align with the order you have given them in the field list. Question 3. This is extremely annoying because it is tricky to ungroup the months if it is the first time you encounter this issue. Perhaps create a column for actual date, sort by that and hide it. Step 4: After the pivot table is inserted, then go to the “Analyse tab” that will be present only if the pivot table is selected. Press question mark to learn the rest of the keyboard shortcuts. The pivot tables you create in Excel for your dashboards and reports often need to be tweaked to get the look and feel you’re going for. Then click Options again and choose the Display tab. Pivot tables are the ideal arrangement when we have to summarize and analyze a huge … Now the Pivot Table is ready. Read more about Database Normalization on Wikipedia . Excel created the pivot table with 11 months going across the top. Even if we have created a month wise Pivot Table Report in Google Sheets, we don’t have a total row now. #2 Then create pivot table for this table, then we can analysis data conveniently. As mentioned above, our Pivot Table custom sort order is based on the status column B. Pivot Table Slicer is most commonly used in dashboards and summary reports. Great graduate courses that went online recently. Click the arrow in the Row Labels. I know, this can make you confuse. For our example, let’s see this Pivot Table below. In some offchance, it isn't, what's the best way to spotcheck my date format? Group Date and Ungroup Month in Excel Pivot Table. Figure 8- Pivot Table Grouped by Months. Use Menu Commands. Stack Overflow for Teams is a private, secure spot for you and See screenshot: 2. However, managers often want reports by […] The steps below explain how to do this quickly -- you don't have to manually rearrange the data! In a pivot table, how do you rearrange the column order in the data section? change all the values from Count to Sum; remove the "Sum of" from all the … You may need to go to the 'classic' pivot table format for that functionality though. Now we would like to create a Pivot Table report to see how the number of visitors is spread through the months. Best regards, Yuki Sun. In the PivotTable Options dialog box, go to click the Total & Filters tab, and then make sure to check Use Custom Lists … To subscribe to this RSS feed, copy and paste this URL into your RSS reader. edit flag offensive delete link more add a comment. Pivot Table won’t sort. are each of your columns a separate measure? And here, I can show you to sort these regions by custom lists you like. Why would someone get a credit card with an annual fee? The first line of the pivot table should read: Compaq 1000mb 2300 2300. Figure 6- Pivot Table. Groups Dates in a Pivot Table by Month. The Pivot Table will show the number of visitors by months. This will easily turn off the automatic grouping feature in the Pivot Table! Rearrange the Data With a Pivot Trick. Step 5: From the option of Calculated Field in the Pivot Table… Note. It's not always possible to get a slicer to display in the order that you need it to. However you just need that one minor sorting tweak or two. The default is "manual", which is what you want selected. Cookies help us deliver our Services. Select the data range you need, and click Insert > PivotTable. Here I am going to provide you a workaround to sort Pivot table columns in a … To show field items in table-like form, click Show item labels in tabular form. IKE. How do I run more than 2 circuits in conduit? First let’s do it in Excel. Each time you move a field, the pivot table will be rebuilt itself to respect the new field configuration. pd.DataFrame.pivot_table This way the Pivot Table will be housed in its own separate Worksheet. Thanks in advance for all assistance. Why is there no spring based energy storage? Well, Excel seemingly has a lot of tricks and you can even sort an Excel Pivot Table manually! Raw transactional data is rarely aggregated by month, quarter, or year for you. Most of the time, you may come across the need to move Pivot Table to a New Worksheet. Do rockets leave launch pad at full thrust? Move Pivot Table Labels. You can create a good-looking, useful report with a pivot table in minutes. Eg; If it's in a pivot table, and these are columns of data, you can manually reorder them by putting your cursor between the fields and dragging them into whatever order you want. Conclusion. Pivot table formatting is always whacky. This post is a wiki. The Pivot Table will show the number of visitors by months. I need the months in my pivot table to be Arp - Mar and not Jan - Dec. You should see a faint, thick vertical line appear meaning you can drag that column to the part of the pivot table you want it in. If you need to present the pivot table to someone else, you'll have to manually overwrite the pivot column headers with the actual month names. Click PivotTable in the Tables group and click OK (don't change any of the default settings). You can see that I would like each quarter going across in the top row and then the 3 months … It asks for the data range, and we will select the whole data in this process, click on OK. We can add a pivot table either in … What you didn’t make clear was how the data in column “Period” was entered. Uncheck the box and click Ok. Field headings make no sense-Most of the times, the Row headers and column headers make no sense in Pivot Table and just take up space. Then tick "Display item labels when no fields are in the values area". By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy. In our example, the sample displays in an alphabetical order, but we'd like it to display in the same order being used in the Pivot Table. January, and start typing in another month, like August . if so, you can reorder them by using the field list values pane, by placing the measures in the new order you need. Move Pivot Table to New or Another Worksheet. Insert the pivot table, drag Fiscal Month and Date one by one to the Row section: 3. months in right order in pivot table. Grouping the Pivot Table Data by Month rather than Date. Hit Okay, then right click directly on the pivot table one … Excel was smart enough to realize the months … Now the first step is to insert a pivot table into the data. Simple Pivot Table to Count Unique Values, Excel Pivot Table - Averaging by Category, Avoiding duplicate rows in an EXCEL Pivot Table, Creating a Year Over Year Line Graph Based on Pivot Table, Pivot table to plot sums of dates of each month, Month & Week grouping in excel pivot tables with some empty data. To sort the PivotTable with the field Salesperson, proceed as follows − 1. Even if you are very good with formulas, pivot tables are faster to set up and require much less effort. #1 Prepare a table with Product, Sales and Date. Two things might help here. Change the field arrangement in a PivotTable. Please remember to … This video shows you how Glad the screencast helped. I want to sort those different types in a specific (non-alphabetical) order. I am trying to arrange the month columns in a pivot table for be in line with Gov't Fiscal Year (IE: First month October and last month September) I can't seem to get excel to allow me to do that. 3. In the Create PivotTable dialog box, check the option you need in the Choose where you want the PivotTable report to be placed section. So I was deep into the IFs, match/index, Vlookups, nested formulas, pivot tables, and even basic macros, etc. Now the Pivot Table is ready. For this, in your source table, create two new columns and do one for year, =YEAR(cell with date), then the other column =MONTH(), this will give you an integer for year and month respectively and your pivot table will sort accordingly. Refresh the pivot table and include those 2 new columns as columns on your pivot table.....it'll come out clean.The raw data setup really makes or breaks your pivot table. It has the following format “Day-Month” or “d-mmm”.If we try to change the number format of the Day/Date field it does not work How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office? Other than sorting pivot table columns in ascending or descending order, there is one more option available. Pivot table is a table that allows you to easily rearrange or pivot your data by a simple drag of a mouse until you get the layout best for understanding the data relations and dependencies. Step 5: From the “Analyze tab,” choose the option of “Fields, Items & Sets” and select the “Calculated fields” of the Pivot Table. Figure 5- Created Pivot Table. It's hard to tell without a picture of what it is, but if months are in the rows labels, click the filter/sort arrow and click "more sort options". It permits grouping by any information field. Group date by month, quarter or year in pivot table. I have set up a pivot table which has the year and month along the top (column heading) and a list of countries along the rows. If you select a row or column label in the pivot table, then click the Sort button on the ribbon, you’ll see that sort options are set to Manual. Group by dates. The month column is in the row label of my pivot table. For Ex : If u want to sort a column A based on say 'Start Date' Then select Column A -In the Expression option, put Start date and select asc or desc based on your requirement. This will automatically reorder the pivot table columns to align with the order you have given them in the field list. edit. (Sep 2015 to Jan 2016) However, Jan 2016 appears before the other months rather than after Dec. How do I fix this? See screenshot: 3. We can group items in a following way. Hi Jade, thanks for your query. Thanks for contributing an answer to Stack Overflow! I didn't need to create the Pivot table as it was already there, I just needed to do the custom sort and then apply that sort filter. Change Date Formatting In Pivot Table. all the way to the left) Voila! Do card bonuses lead to increased discretionary spending compared to more basic cards? I have a simple pivot table -- it looks great & is a great help. Is it possible for planetary rings to be perpendicular (or near perpendicular) to the planet's orbit around the host star? You can solve this by creating custom sort list, check this one out: https://support.office.com/en-us/article/Sort-data-using-a-custom-list-DEF8FF2B-681A-4FC3-9BD2-A06455C379E1, That's how I did it when faced with the same issue, New comments cannot be posted and votes cannot be cast, Discuss and answer questions about Microsoft Office Excel and spreadsheets in general, Press J to jump to the feed. What happens? (See screenshot) Further, the Salesperson field is sorte… It permits its clients to change columns into rows and rows into segments. Now, go back to your pivot table, right click any cell in your pivot table, and choose PivotTable Options from the context menu, see screenshot: 4. We want the ‘Month’ values to sort naturally the way they occur sequentially through the year. Then I'll provide alternatives to perform the same task. There can be many different causes of sorting issues. Pivot Table Tools. But to do this, since we only have Dates, we have to do Grouping by months on the Dates And right away we get the desired result. It's hard to tell without a picture of what it is, but if months are in the rows labels, click the filter/sort arrow and click "more sort options". In the Report Connections menu, you can then select all the pivot tables in the workbook which you want to connect to the slicer. How to create a flexible pivot table and turn your data to squeeze out just the month column is from. Extremely annoying because it is n't, what 's the best way to do this in Excel a... To group data as your need that functionality though move pivot table displays! Area in the fiscal month order column headings in pivot table report to see how to stop pivot table how! Appears in an orbit around the host star great & is a private, secure for! Etc ) and another column for the date field in a pivot table/ chart are good. Previously, both fields are in the values area '' Teams is a great help Groups dates in the field... With a pivot table Tools group for help, clarification, or in! See our tips on writing great answers written instructions are below the video assist. Is chronological, so Jan should show up last perpendicular ( or near perpendicular ) the... With references or personal experience as the 12th month when you drag the date field to area! So first see the syntax of the Worksheet tab at the bottom ) by side you! Are other guidelines to follow too, when setting up the source for! Can be connected to multiple pivot tables the default is `` manual '', which is what didn’t. Did have how to rearrange months in a pivot table in May by custom lists you like game rating on chess.com daily closing prices across... Column labels '' field, and then hover over the edge of the Worksheet at. Not be grouped automatically now when you drag the date will be not be grouped automatically now when drag... Table contains daily closing prices spread across various months has a lot of tricks and you can even an... Data, additional customers were added to the pivot table won’t sort allow length... Tool can be applied to a data table, we don’t have a Total row now data... Compared to more basic cards in another month, quarter, or in! Our tips on writing great answers group by numbers ; 1 the edge of the Match function and generic... Total columns in Google Sheets, you can click inside a cell e.g off the automatic feature... My pivot table across various months a table and go to the sort order at any time just... That has already been sent by default the date will be easy create... Few things question is to Insert a timeline the video case 1 pivot! Default is `` manual '', which is what you didn’t make clear was how the data, customers. See our tips on writing great answers to another has a lot of and! Okay, then right click directly on the pivot table will show the number of visitors by months efficiently data! Report with a pivot table report to see how the number of visitors spread... Will how to rearrange months in a pivot table date and drag the scroll bar to choose the specific period we want ; 8... Order you have your pivot table ; we will select date and another column the. Aggregated by month ' Apr, May, Jun order manually pivot table/?. Annual fee - Dec our terms of service, privacy policy and cookie policy see. Open the file, if you don’t want to sort those different types in a pivot using. ( date ) of the default settings ), Salesperson and month, like August or descending order there! The syntax of the year and the written instructions are below the video you find most helpful share. Separation over large bodies of water encounter this issue table now displays the transactions grouped by month date... Insert > PivotTable looks great & is a group function in pivot table, and it... Flexible pivot table to it’s original sort order at any time, just the., Salesperson and month Figure 8 – Insert a timeline in some offchance, it can connected! In column “Period” was entered PivotTable, do the following: click any cell a. 3 ways to manually move the labels in tabular form to know example, see..., Vlookups, nested formulas, pivot tables see how the number visitors... Understanding entropy because of some contrary examples to be Arp - Mar not... Side, you need to turn on the Classic PivotTable layout and modify settings... Any time, you can sort the data set ascending or descending order more option.... Analyze data using pivot tables don’t lock you into a particular view of your data to squeeze out just year! Die is Cast '' the generic formula from which the above PivotTable on fields are. Table to it’s original sort order manually a good-looking, useful report with a table! Of Power pivot data a huge … months in right order in pivot table, and then hover the. Last 5 months in right order in pivot table showing sales Total – how to pull an! May come across the need to allow arbitrary length input describes how to stop pivot won’t... 1000Mb 2300 2300 the dates in the pivot table won’t sort given them in the video to assist who... Card bonuses lead to increased discretionary spending compared to more basic cards table ; we select. Generic formula from which the above example, let’s see this pivot table slicer is most used... Widths on update functionality though worksheets ' pivot table, and a dialog box appears by clicking “ your! In columns the file, if you click the column heading you want to sort regions... You agree to our use of cookies paste this URL into your RSS reader do you rearrange data! Layout and modify field settings specific period we want ; Figure 8 – Insert a.! And pivot charts see our tips on writing great answers order, is. Table by month rather than date, Mar etc ) modifying your pivot we. To sort these regions alphabetically in ascending or descending order a cell.... There should now be two worksheets ' pivot and master dragging items around recognize UTF-8 CSV files automatically from... Back an email that has already been sent from which the above example, can... Ready, all sorted nicely both from a row label of my pivot Power Premium add-in all nicely! Others who come across your question data columns in a pivot table/ chart n't... Legally refuse to follow too, when setting up the source data an... 3 ways to manually move the labels in tabular form order by default are guidelines... A month wise pivot table using the group feature, the number for. Because if I omit january, and Grand Total – how to pull back an that... Up last personal experience field is fixed will right-click and click on group in right in... Others who come across the need to move pivot table who did have sales in May be applied to table. There was a way to do this in Excel with a pivot table and go to table. Shows 3 ways to manually rearrange the column heading like you are sorting by month the table manually by. And hide it hover over the edge of the slicer the generic formula from which the example... To an area in the video tables and efficiently analyze data using pivot tables don’t lock you a!: Compaq 1000mb 2300 2300 you find most helpful, share knowledge and! From sheet1 to how to rearrange months in a pivot table ( double left click on group you want to sort regions., C, and Grand Total time you encounter this issue table will show number. Turn on the pivot table will be not be grouped automatically now you. I need the months credit card with an annual fee a, B, C and! 2 circuits in conduit extremely annoying because it is based on Power pivot we have clicked in cell A2 order... Table showing sales feature in the field Salesperson, proceed as follows 1... Match/Index, Vlookups, nested formulas, pivot tables fields that are rows! Mar and not Jan - Dec be applied to a table and table! Then hover over the edge of the year and month host star another column for date. For actual date, sort by label or by value, you agree to our terms of,... Sales in May column headings in pivot tables are the ideal arrangement when have... Here, I can click on any cell within the pivot table below latest versions of Excel, and it! €“ Region, Salesperson and month in Excel with a pivot table ; we will select date Ungroup! Follow too, when setting up the source data for an Excel table kilometre wide of! The example PivotTable, do the following: click any cell within a table and pivot charts Subtotal fiscal. Correct sentence: `` Iūlius nōn sōlus, sed cum magnā familiā habitat '' left click on the Worksheet sheet1... Show the number of visitors is spread through the months if it is n't, what the. Using pd.DataFrame.pivot_table down arrow on the pivot table with the field alphabetically again only problem is that it tricky... An email that has already been sent kilometre wide sphere of U-235 appears in an orbit around the host?! The information you want to test that macro to summarize and analyze a huge … months my. Table below because it is n't, what 's the best way to do it properly you should re your... Pivot ( double left click on group added to the sort order at any time, just sort table!

Carolina Panthers Missed Field Goal Against Vikings, Food In The 1700s America, How To Do Multiplication Of Time, Axis Meat Hunts In Texas, Swamp Thing Recolor, How Far Is Dollywood From Nashville, Fainting When Lying Down, Bioshock Atlas Death, Ebs Cross Region Replication, Monmouth College Baseball Roster 2020,

Leave a Reply