Open your Google Sheet and go to Data > Pivot table. How to create a pivot table in Google Sheets - Data > Pivot Table. 2. Select the range of data you will use to create the pivot table. Here, I have selected the suggested range, which includes all data in the sheet. Click “OK”.Add a new sheet. On the pivot table sheet, step over a column so that you are outside the table, and enter the formula =Count(X:X) where X is the last column of the pivot table. Count only counts cells with numeric data. If you have strings, then I'd be interested in what you are pivoting.How do I refresh my pivot table in google sheet? - Google Docs Editors Community. Google Docs Editors Help. Sign in. Help Center. Community. Google Docs Editors.In the example picture, I have a basic conditional format set to highlight the words Home and Home Connect.. I am looking for a formula or query that will dynamically extend the conditional format colour to fill the blank cells in the column to group all the Home topics. as well as the word without formatting the entire row or column.Connect a slicer/filter to multiple Pivot Tables with different data sources in Google Sheets.Live Classes https://www.chicagocomputerclasses.com/youtube-lea...Record macros or use Google Apps Script: Create filters: Create filters and filter views: Insert recommended pivot tables or create one manually: Create pivot tables manually or automatically with Explore: Create charts manually: Create charts manually or automatically with Explore: Set notifications in OneDrive: Set notifications in Sheets So, let’s begin to learn to sort Pivot Table columns in Google Sheets. Step #1 – Open the Pivot Table Editor. Go to the spreadsheet containing the Pivot Table. The Pivot Table editor will be displayed on the right side of the screen by default. If you don’t see it, you must open it manually by following the steps below.Mar 2, 2022 · Step 3: Create the Pivot Table. To create the pivot table, we’ll highlight the values in the range A1:C21, then click the Insert tab and then click Pivot table. We can then create the following pivot table: The final pivot table includes data from both the week1 and week2 sheets. 1. An Introduction to Pivot Tables in Google Sheets What are Pivot Tables? Let’s see a super simple example, to demonstrate how Pivot Tables work. Consider this dataset: You want to summarize the data and answer questions like: how many apartments are there in the dataset? What’s the total cost of all the apartments?The filters are applied before aggregating data into the pivot table. The map's key is the column offset of the source range that you want to filter, and the value is the criteria for that column. For example, if the source was C10:E15 , a key of 0 will have the filter for column C , whereas the key 1 is for column D .Home Google What are Pivot Tables in Google Sheets, and How Do I Use Them By Brady Gavin Published Mar 21, 2019 Google Sheets lets you analyze and summarize large amounts of data with pivot tables. Here's how to use them. Readers like you help support How-To Geek.Mar 1, 2021 · You can accept a suggestion to make an instant pivot table or create one manually. Open the spreadsheet in Google Sheets that has the data you want to use. Select the table containing the source data you want to use. Select Insert > Pivot Table . A new sheet opens, and the Pivot Table Editor opens on the right side of the screen. Step 2: Create a named range for this cell with the string in. Click on the formula cell, click on Data > Named ranges... and give it a name, e.g. dynamicRange. Step 3: Combine this named range with the INDIRECT function to refer to this string range inside your other formulas, which gives you a dynamic named range.Step 6. Next, we’ll try to change the number formatting for a particular field. Select a field in your pivot table by clicking on the column header of that field. Step 7. For number formatting, Google Sheets provides several options such as converting numerical values to a currency, displaying decimals as percentage, and more. Basic Running total. Let’s start off with the most basic method, using a standard (non-Array) formula which we can then copy down our column. Taking the dataset above, we start our running total in cell C2, with this formula: = B2. It simply returns our first value, which is our only value at this stage. For our second value onwards, we can ...Jun 13, 2020 · In the example picture, I have a basic conditional format set to highlight the words Home and Home Connect.. I am looking for a formula or query that will dynamically extend the conditional format colour to fill the blank cells in the column to group all the Home topics. as well as the word without formatting the entire row or column. Home Google What are Pivot Tables in Google Sheets, and How Do I Use Them By Brady Gavin Published Mar 21, 2019 Google Sheets lets you analyze and summarize large amounts of data with pivot tables. Here's how to use them. Readers like you help support How-To Geek.In the example picture, I have a basic conditional format set to highlight the words Home and Home Connect.. I am looking for a formula or query that will dynamically extend the conditional format colour to fill the blank cells in the column to group all the Home topics. as well as the word without formatting the entire row or column.This help content & information General Help Center experience. Search. Clear searchPivot tables in Google Sheets are a game-changer for efficient data analysis. They are versatile, flexible, and essentially faster to use for exploring your data than spreadsheet formulas. This guide takes a comprehensive look into pivot tables in Google Sheets, why you should use them, and a few tips on creating your first pivot table.On your computer, open a spreadsheet in Google Sheets. Select the cells with source data you want to use. Important: Each column needs a header. In the menu at the top, click Insert Pivot...Learn how to create Pivot Tables and Charts in Google Sheets to see and forecast trends to make data driven decisions.How to slides: https://docs.google.com...In Google Sheets, is there any way that the "Grand Total" of a column in a Pivot Table is something different than the values of the column represents? (for instance, in a sum column, show the average). An example would be in a sheet with daily sales of several products.Create pivot tables in Google Sheets. Select all the data (including the headers) by selecting the bottom- right corner cell and pressing Ctrl + A. Select Data and then Pivot tables from the menu ...GETPIVOTDATA (value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]) value_name - The name of the value in the pivot table for which you want to get data. value_name must be enclosed in quotation marks or be a reference to any cell containing the appropriate text. If there is more than one value field, you have to use the ...This help content & information General Help Center experience. Search. Clear searchI tried using a calculated field for a pivot table in Google Sheets. For example, there are two pivot table columns, Column1 and Column2, containing numbers. In the calculated field, I write for example =Column1+Column2. In my case, this is the exact formula: =ROUNDDOWN((Cheating*25)-('Not Cheating'*100), -3) The result is correctly displayed.This help content & information General Help Center experience. Search. Clear search Apr 28, 2023 · Click the menu Data > Pivot table. You will see a dialogue window, asking whether you want to create a pivot table in a new sheet or in the existing sheet. If you choose “New sheet”, this will create a new tab in your sheet called “Pivot Table 1” with a blank Pivot Table that you can start filling in. time world buddy
GETPIVOTDATA (value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]) value_name - The name of the value in the pivot table for which you want to get data. value_name must be enclosed in quotation marks or be a reference to any cell containing the appropriate text. If there is more than one value field, you have to use the ... Pivot tables help you summarize and analyze large data sets by displaying the information in more digestible formats. They make it much easier to take out small pieces of information and conclusions from a large set of information. To create a pivot table in a Google Sheet, first select all of your data. Then go to Data on the top menu.Add a new sheet. On the pivot table sheet, step over a column so that you are outside the table, and enter the formula =Count(X:X) where X is the last column of the pivot table. Count only counts cells with numeric data. If you have strings, then I'd be interested in what you are pivoting.Apr 4, 2022 · Open your Google Sheet and go to Data > Pivot table. How to create a pivot table in Google Sheets - Data > Pivot Table. 2. Select the range of data you will use to create the pivot table. Here, I have selected the suggested range, which includes all data in the sheet. Click “OK”. On your computer, open a spreadsheet at sheets.google.com. Click the chart or pivot table you want to filter. At the top, click Data Add a slicer. At the right, choose a column to filter by. Filter by condition: Choose from a list of conditions or create your own. Filter by values: Uncheck any data points that you want to hide.Google Sheets now supports this as 'Create pivot date group'. In the Pivot table, once you've added your date/time column as rows: Right-click on one of the values in the Pivot table, Choose 'Create pivot date group'. Choose the desired grouping (e.g., 'Month' or 'Year-Month')Apr 26, 2020 · How to Pivot Multiple Columns in Query in Google Sheets. All About Calculated Field in Pivot Table in Google Sheets. How to Sort Pivot Table Grand Total Columns in Google Sheets. How to Sort Pivot Table Columns in the Custom Order in Google Sheets. Extract Total and Grand Total Rows From a Pivot Table in Google Sheets. How to Filter Top 10 ... Menambahkan atau mengedit tabel pivot. Pada komputer Anda, buka spreadsheet di Google Spreadsheet. Pilih sel dengan data sumber yang ingin Anda gunakan. Penting: Setiap kolom membutuhkan header. Pada menu di bagian atas, klik Sisipkan Tabel pivot. Jika belum terbuka, klik sheet tabel pivot. Pada panel samping, di sebelah "Baris" atau "Kolom ... Cach-tao-Pivot-Table-trong-google-sheets-5. Hãy cùng xem cách làm việc với PivotTable trong Google Sheets. Để thêm hàng hoặc một cột vào PivotTable trên Google Sheets, chỉ cần nhấp vào “Add” và chọn các truoenfg bạn cần phân tích: Cach-tao-Pivot-Table-trong-google-sheets-6On the Pivot table editor panel, add a “Calculated Field” to Values by clicking the “Add” button against “Values.”. Remove the existing formula, i.e., =0 in the formula entry field that appears. Select “Custom” under summarize by. Insert the following XLOOKUP formula. Click outside the formula field to activate it, and voila!Learn how to create a pivot table using multiple worksheets in Google Sheets. This tutorial covers cases with matching or not matching columns, as well as dy...smart recruiter
Open an existing spreadsheet in Google Sheets. Select Data from the top menu, then Pivot table from the dropdown. Create your pivot table using your entire or selected data range in a new or ...By Administrator. Apa yang harus diketahui tentang cara membuat pivot table di Google Sheet: Format data sebagai tabel dengan memilih sel yang berisi data dan klik tombol Filter pada toolbar. Pilih tabel yang berisi sumber data yang ingin Anda gunakan, lalu pilih Data > Pivot Table. Pilih salah satu pivot table yang disarankan di bagian atas ...Select A1:C9. Go to the Insert menu and select Pivot Table. I’m creating the report in the source sheet. So check the “Existing sheet” option. Enter E1 in the field immediately below the above option and select the “Create” button. Drag and drop “Name” and then “Subject” under “Row.”. This help content & information General Help Center experience. Search. Clear search In Google Sheets, is there any way that the "Grand Total" of a column in a Pivot Table is something different than the values of the column represents? (for instance, in a sum column, show the average). An example would be in a sheet with daily sales of several products.การสร้างและใช้งาน Pivot Table ใน Google Sheets สำหรับคนที่ใช้งาน โปรแกรมจัดการตารางข้อมูล อย่าง Microsoft Excel ที่พัฒนาโดยบริษัท Microsoft ยักษ์ใหญ่แห่งวงการไอที ที่เรา ...Nov 24, 2021 · To make a Pivot Table, we need to go to the Insert menu and click on Pivot Table. However, in some instances, Google Sheets will not show the Pivot Table under the Insert menu. What you can do is click on the ‘ Help ‘ menu on the toolbar. After clicking the Help menu, a search bar will pop up. Type in ‘ Pivot Table ‘ in the search bar. Mar 14, 2021 · By Administrator. Apa yang harus diketahui tentang cara membuat pivot table di Google Sheet: Format data sebagai tabel dengan memilih sel yang berisi data dan klik tombol Filter pada toolbar. Pilih tabel yang berisi sumber data yang ingin Anda gunakan, lalu pilih Data > Pivot Table. Pilih salah satu pivot table yang disarankan di bagian atas ... afro circus
Step 2: Create a pivot table from Combined_Data. Select a cell in the "Combined_Data" sheet. Click on "Data" in the menu bar and choose "Pivot table." The range should be pre-filled with the combined data. Choose where you want the pivot table to appear and click "Create." This help content & information General Help Center experience. Search. Clear search Jan 17, 2019 · ArrayFormula function supported by Google Sheets is a powerful function. Using ArrayFormula, one can speed things up, by avoiding manual updates. Before using pivot table, we should be aware that… On the Pivot table editor panel, add a “Calculated Field” to Values by clicking the “Add” button against “Values.”. Remove the existing formula, i.e., =0 in the formula entry field that appears. Select “Custom” under summarize by. Insert the following XLOOKUP formula. Click outside the formula field to activate it, and voila!Aug 12, 2023 · Pivot tables provide a way to summarize data in your spreadsheet, automatically aggregating, sorting, counting, or averaging the data while displaying the summarized results in a new table. A pivot table acts as a sort of query against a source data set. This source data exists at some other location in the spreadsheet, and the pivot table ... Click the menu Data > Pivot table. You will see a dialogue window, asking whether you want to create a pivot table in a new sheet or in the existing sheet. If you choose “New sheet”, this will create a new tab in your sheet called “Pivot Table 1” with a blank Pivot Table that you can start filling in.Pivot Table Steps to Calculate Percent of Grand Total in Sheets. Select the array B1:C5. Needless to say, if your data range is different, select that range. Click the ‘Data’ menu and select the menu item ‘Pivot table’. Follow the on-screen instructions to create the Pivot Table in the ‘New sheet’ or ‘Existing sheet’.Aug 2, 2019 · Create a Pivot Table. If you’re new to Pivot Tables, have a read of Pivot Tables in Google Sheets: A Beginner’s Guide. Back in the real estate dataset, insert a Pivot Table: Data > Pivot Table. Create a simple Pivot Table in a new Sheet, for example this one shows property types and total sales price for each category: Add a Slicer Control Mar 1, 2021 · You can accept a suggestion to make an instant pivot table or create one manually. Open the spreadsheet in Google Sheets that has the data you want to use. Select the table containing the source data you want to use. Select Insert > Pivot Table . A new sheet opens, and the Pivot Table Editor opens on the right side of the screen. Learn how to create a pivot table using multiple worksheets in Google Sheets. This tutorial covers cases with matching or not matching columns, as well as dy...Open your Google Sheet and go to Data > Pivot table. How to create a pivot table in Google Sheets - Data > Pivot Table. 2. Select the range of data you will use to create the pivot table. Here, I have selected the suggested range, which includes all data in the sheet. Click “OK”.You can choose a set of values in a pivot table and group them together manually or with a rule. On your computer, open a spreadsheet in Google Sheets. Click the pop-up Edit button underneath the pivot table. To manually group: Right-click the cells, then click Create pivot group. Select the cells you want to group together.The goal is a pivot table with MM-YYYY in the column, summing amounts by the month/year. Usually, that's easy. I create the pivot table with the ungrouped variable in the column, and then right click and create a pivot table group. However, when I create a pivot table with the date as the column of the table, Google Sheets saysMay 5, 2023 · Google Sheets pivot table is a perfect solution for such a task. A Pivot table can help you in presenting your data in a more convenient and understandable form. The main handy feature of a pivot table is its ability to move the fields interactively, to filter, group and sort the data, to calculate the sums and the average values. There are two solutions you can do if this is your issue. The first solution is to always create your pivot table with extra rows and columns so that you can add more data if you need to. The next solution is to insert new rows or columns in between the already existing data. If you add new data in between existing data, your pivot table range ... wedgie stories
Step 6. Next, we’ll try to change the number formatting for a particular field. Select a field in your pivot table by clicking on the column header of that field. Step 7. For number formatting, Google Sheets provides several options such as converting numerical values to a currency, displaying decimals as percentage, and more.First, open a web browser instance with a tab showing the Google spreadsheet that has your pivot table in it. Hit the Refresh button near the top part of your browser window and wait for the tab to reload. Your Google Sheets pivot table should refresh along with the entire spreadsheet. Alternatively, you can hit the F5 button, which serves as a ...In such situations, you may have to write the formula: #1) click Add value. #2) select "Custom" in the "Summarise by" field. #3) change the Formula field from "=0" to "=counta ('Year Certified')" P.S.: 'Year Certified' is the column name in the sample data set I'm using for this illustration. Change it to whatever column name appropriate for ...Oct 30, 2020 · In such situations, you may have to write the formula: #1) click Add value. #2) select "Custom" in the "Summarise by" field. #3) change the Formula field from "=0" to "=counta ('Year Certified')" P.S.: 'Year Certified' is the column name in the sample data set I'm using for this illustration. Change it to whatever column name appropriate for ... Aug 12, 2023 · Pivot tables provide a way to summarize data in your spreadsheet, automatically aggregating, sorting, counting, or averaging the data while displaying the summarized results in a new table. A pivot table acts as a sort of query against a source data set. This source data exists at some other location in the spreadsheet, and the pivot table ... This help content & information General Help Center experience. Search. Clear searchLearn how to create Pivot Tables and Charts in Google Sheets to see and forecast trends to make data driven decisions.How to slides: https://docs.google.com...With Google Sheets’ advanced pivot table features, you can customize and edit pivot table style with just a few clicks! Functions, calculations, and other analyses are even simpler with pivot tables. In this guide, we’ll teach you how to create and how to use a pivot table in Google Sheets to summarize and analyze your data effectively.Step 1. Open the Pivot Table Editor, scroll to the list of filters at the bottom, and click on the X beside each filter you want to delete. Start with the filters most likely to be causing the problem. These will be the ones filtering on fields that have new values in the newly added data.Step 3: Using the Pivot Table Editor to Add Dates. On the right side of the screen, you’ll see a box named ‘Pivot table editor.’ With the help of this box, you can add the values from the previous sheet into your pivot table. Let’s add the ‘Dates’ column: Click the ‘Add’ button next to the ‘Rows’ in the editor.This help content & information General Help Center experience. Search. Clear search Dec 28, 2022 · Make a pivot table using the Explore button. Click the Explore button in the lower-right corner of the window to open the Explore pane. Click Pivot Table to see a preview of the table. Click ... Access Google Sheets with a personal Google account or Google Workspace account (for business use). Pivot tables are a tool inside Google Sheets that lets you quickly and easily analyze, explore, summarize and present your data. They are arguably the most powerful feature of Google Sheets. Using a familiar drag-and-drop interface, you can answer vital business questions by exploring your data interactively. Steps involved in Subtotal and Grouping in Google Sheets. 1. Insert new rows below each group. You can see the newly inserted rows in the image below (rows #3, 12, 19, 22, and 26). 2. Then, insert one helper column after column B and type the text strings as per the screenshot below (column C) in those rows. 3.advertiser tribuneSo, let’s begin to learn to sort Pivot Table columns in Google Sheets. Step #1 – Open the Pivot Table Editor. Go to the spreadsheet containing the Pivot Table. The Pivot Table editor will be displayed on the right side of the screen by default. If you don’t see it, you must open it manually by following the steps below.I have the following data in my sheet: What I am trying to achieve is a pivot table like this (where the columns are values of the "Date of P&L" column, rows are "CF/P&L/BS Account" columns' values, and values of the cells are summary of the "Sum" column): I already figured out I can use the built-in pivot table module in Google Sheets.Dec 23, 2022 · I have the following data in my sheet: What I am trying to achieve is a pivot table like this (where the columns are values of the "Date of P&L" column, rows are "CF/P&L/BS Account" columns' values, and values of the cells are summary of the "Sum" column): I already figured out I can use the built-in pivot table module in Google Sheets. There are two solutions you can do if this is your issue. The first solution is to always create your pivot table with extra rows and columns so that you can add more data if you need to. The next solution is to insert new rows or columns in between the already existing data. If you add new data in between existing data, your pivot table range ...Mar 1, 2021 · You can accept a suggestion to make an instant pivot table or create one manually. Open the spreadsheet in Google Sheets that has the data you want to use. Select the table containing the source data you want to use. Select Insert > Pivot Table . A new sheet opens, and the Pivot Table Editor opens on the right side of the screen. Jul 12, 2023 · First, open a web browser instance with a tab showing the Google spreadsheet that has your pivot table in it. Hit the Refresh button near the top part of your browser window and wait for the tab to reload. Your Google Sheets pivot table should refresh along with the entire spreadsheet. Alternatively, you can hit the F5 button, which serves as a ... How do I refresh my pivot table in google sheet? - Google Docs Editors Community. Google Docs Editors Help. Sign in. Help Center. Community. Google Docs Editors. Step 2: Create a pivot table from Combined_Data. Select a cell in the "Combined_Data" sheet. Click on "Data" in the menu bar and choose "Pivot table." The range should be pre-filled with the combined data. Choose where you want the pivot table to appear and click "Create." Aug 6, 2019 · Dynamic Range in Google Sheets Pivot Table. I want to build pivot table with dynamic range in "Google Sheets". Please help me with the same. In Microsoft Excel we can achieve this with Offset function in pivot table. I am looking for similar solution. I have tried using Named Range, Offset Function and also app script but none of them is working. Steps: Click on the “Filters” option on the Pivot table editor panel, click “Add” and choose the field “Attempt.”. Then choose “Filter by condition” and under it, select “Text does not contain.”. Enter the value “2nd” and click OK. You can refer to the below image.Mar 14, 2021 · By Administrator. Apa yang harus diketahui tentang cara membuat pivot table di Google Sheet: Format data sebagai tabel dengan memilih sel yang berisi data dan klik tombol Filter pada toolbar. Pilih tabel yang berisi sumber data yang ingin Anda gunakan, lalu pilih Data > Pivot Table. Pilih salah satu pivot table yang disarankan di bagian atas ... Initially, everything appears the same with the exact results. However, if we filter the results by month and get the Google Sheets subtotal filter, we will begin seeing the differences. To do this, Step 1: select the green filter drop-down at the top of the Month column. Step 2: Select the month in question and hit OK.Select A1:C9. Go to the Insert menu and select Pivot Table. I’m creating the report in the source sheet. So check the “Existing sheet” option. Enter E1 in the field immediately below the above option and select the “Create” button. Drag and drop “Name” and then “Subject” under “Row.”. GETPIVOTDATA (value_name, any_pivot_table_cell, [original_column, ...], [pivot_item, ...]) value_name - The name of the value in the pivot table for which you want to get data. value_name must be enclosed in quotation marks or be a reference to any cell containing the appropriate text. If there is more than one value field, you have to use the ...rapido
Jul 12, 2023 · First, open a web browser instance with a tab showing the Google spreadsheet that has your pivot table in it. Hit the Refresh button near the top part of your browser window and wait for the tab to reload. Your Google Sheets pivot table should refresh along with the entire spreadsheet. Alternatively, you can hit the F5 button, which serves as a ... The Google Sheets API lets you create and update pivot tables within spreadsheets. The examples on this page illustrate how you can achieve some common pivot table operations with the Sheets API. These examples are presented in the form of HTTP requests to be language neutral. To learn how to implement a batch update in different languages ...On the Pivot table editor panel, add a “Calculated Field” to Values by clicking the “Add” button against “Values.”. Remove the existing formula, i.e., =0 in the formula entry field that appears. Select “Custom” under summarize by. Insert the following XLOOKUP formula. Click outside the formula field to activate it, and voila!I have the following data in my sheet: What I am trying to achieve is a pivot table like this (where the columns are values of the "Date of P&L" column, rows are "CF/P&L/BS Account" columns' values, and values of the cells are summary of the "Sum" column): I already figured out I can use the built-in pivot table module in Google Sheets.Logic to Filter the Top 3 Values from Each Group in the Pivot Table in Google Sheets. Coding Custom Formula for the Report # 1. Step # 1 – RC Formula. Step # 2 – Running Count (RC) Sorting by Sales. Step # 3 – Combine Product and Sales Based on Sorted RC. On your computer, open a spreadsheet in Google Sheets. Select the cells with source data you want to use. Important: Each column needs a header. In the menu at the top, click Insert Pivot...Jul 18, 2023 · Initially, everything appears the same with the exact results. However, if we filter the results by month and get the Google Sheets subtotal filter, we will begin seeing the differences. To do this, Step 1: select the green filter drop-down at the top of the Month column. Step 2: Select the month in question and hit OK. Apr 28, 2023 · Click the menu Data > Pivot table. You will see a dialogue window, asking whether you want to create a pivot table in a new sheet or in the existing sheet. If you choose “New sheet”, this will create a new tab in your sheet called “Pivot Table 1” with a blank Pivot Table that you can start filling in. snow ball io
Aug 2, 2019 · Create a Pivot Table. If you’re new to Pivot Tables, have a read of Pivot Tables in Google Sheets: A Beginner’s Guide. Back in the real estate dataset, insert a Pivot Table: Data > Pivot Table. Create a simple Pivot Table in a new Sheet, for example this one shows property types and total sales price for each category: Add a Slicer Control Basic Running total. Let’s start off with the most basic method, using a standard (non-Array) formula which we can then copy down our column. Taking the dataset above, we start our running total in cell C2, with this formula: = B2. It simply returns our first value, which is our only value at this stage. For our second value onwards, we can ...Dec 28, 2022 · Make a pivot table using the Explore button. Click the Explore button in the lower-right corner of the window to open the Explore pane. Click Pivot Table to see a preview of the table. Click ... Step 6. Next, we’ll try to change the number formatting for a particular field. Select a field in your pivot table by clicking on the column header of that field. Step 7. For number formatting, Google Sheets provides several options such as converting numerical values to a currency, displaying decimals as percentage, and more.