Hi,

Hope all are well.

Just a small help in pivot table in attached file.

The pivot table shows counts of Batches and Incidents. However, i want**average monthly values** under Batches, Incidents and average Incident %.

Can someone please help?

Hope all are well.

Just a small help in pivot table in attached file.

The pivot table shows counts of Batches and Incidents. However, i want

Can someone please help?

Hello

I found this chart online, but it was not showing all formulas and i dont know if i have done right

The mounth is splitted in different size after of many activity it haves

I found this chart online, but it was not showing all formulas and i dont know if i have done right

The mounth is splitted in different size after of many activity it haves

Hello,

I am working on coming up with a distribution table for our team where I need to show distinct sample lines that were shipped (not the number of vials actually shipped). So for instance, if we ship 2 vials per sample line, it should show two lines were sent, not 4 vials.

My issue arises when I attempt to make the pivot table with distinct count of the subject ID and change the cascade. When fully expanded, the information is correct. But once collapsed the information changes. In the excel, this is seen at the samples sent to Adam Smith. When expanded to sample type or subject ID level, the distinct count works correctly, showing that we sent 4 sample lines (1 per patient per type). But when I collapse this to Adam, it shows 2 (I'm assuming this number reflects the number of shipments, not line sent per patient per type). Is there a formula that I could add to the data model in this chart that would help counteract this error? I looked at a concatenateX, but it didn't do anything to help. I am thinking I need a distinct count that I can say if info in one of three columns is different, count it. Not sure if that is even possible.

Basically, I need it to show how may lines per patient per type were sent to each location, investigator, and type, without counting the actual number of vials. I don't need to know we sent 15 vials to a location, just how many different lines and types were sent.

Any help appreciated in advance!!

I am working on coming up with a distribution table for our team where I need to show distinct sample lines that were shipped (not the number of vials actually shipped). So for instance, if we ship 2 vials per sample line, it should show two lines were sent, not 4 vials.

My issue arises when I attempt to make the pivot table with distinct count of the subject ID and change the cascade. When fully expanded, the information is correct. But once collapsed the information changes. In the excel, this is seen at the samples sent to Adam Smith. When expanded to sample type or subject ID level, the distinct count works correctly, showing that we sent 4 sample lines (1 per patient per type). But when I collapse this to Adam, it shows 2 (I'm assuming this number reflects the number of shipments, not line sent per patient per type). Is there a formula that I could add to the data model in this chart that would help counteract this error? I looked at a concatenateX, but it didn't do anything to help. I am thinking I need a distinct count that I can say if info in one of three columns is different, count it. Not sure if that is even possible.

Basically, I need it to show how may lines per patient per type were sent to each location, investigator, and type, without counting the actual number of vials. I don't need to know we sent 15 vials to a location, just how many different lines and types were sent.

Any help appreciated in advance!!

Hi everyone,

I have a pivot table that summarizes user feedback on a coffee store. The original data has the user's actual feedback (User Comment), and I assigned a category to each feedback and the category groups the feedback based on their similarities (Category). Next, I assigned a higher-level category that groups the Category (Topic).

In sum, there are multiple groupings, with User Comment (raw data) <- Category (2nd level of grouping) <- Topic (1st level of grouping).

The pivot table summarizes the Topic and shows the Category underneath the Topic in a column.

What I want is this: I want to click each Category in the table and have**three random** user feedback associated with that category appear on the right side of the table.

Right now, 'Show Details' does not quite do what I want. Is there a way to do what I want either using a Slicer/Macro or any other means?

I'd really appreciate your insights.

I have a pivot table that summarizes user feedback on a coffee store. The original data has the user's actual feedback (User Comment), and I assigned a category to each feedback and the category groups the feedback based on their similarities (Category). Next, I assigned a higher-level category that groups the Category (Topic).

In sum, there are multiple groupings, with User Comment (raw data) <- Category (2nd level of grouping) <- Topic (1st level of grouping).

The pivot table summarizes the Topic and shows the Category underneath the Topic in a column.

What I want is this: I want to click each Category in the table and have

Right now, 'Show Details' does not quite do what I want. Is there a way to do what I want either using a Slicer/Macro or any other means?

I'd really appreciate your insights.

I have sets of data for each year by month. See below for an example. I also have these sets for 2021 and 2023.

Month Day Night

Jan-22 503 103

Feb-22 244 72

Mar-22 169 49

Apr-22 62 34

May-22 34 0

Jun-22 42 0

Jul-22 40 0

Aug-22 37 0

Sep-22 74 0

Oct-22 76 64

Nov-22 335 99

Dec-22 472 140

I can easily produce a stacked column chart that shows the data for one year. However, to enable easier comparison, I would like to generate a stacked column chart that shows Jan 22's data alongside Jan 23's data and so on for the full year.

Is this possible in Excel charts?

]]>Month Day Night

Jan-22 503 103

Feb-22 244 72

Mar-22 169 49

Apr-22 62 34

May-22 34 0

Jun-22 42 0

Jul-22 40 0

Aug-22 37 0

Sep-22 74 0

Oct-22 76 64

Nov-22 335 99

Dec-22 472 140

I can easily produce a stacked column chart that shows the data for one year. However, to enable easier comparison, I would like to generate a stacked column chart that shows Jan 22's data alongside Jan 23's data and so on for the full year.

Is this possible in Excel charts?

Hi all,

I am trying to create a graph with (time) in which there is no Y axis, but only a X axis, it is to show how long it will take to escape. It is meant to show after one point, another would go straight after it, ideally I would like it to look like the attached The-egress-time-model-The-RSET-should-be-shorter-than-the-ASET-Reproduced-from-Proulx.png

]]>I am trying to create a graph with (time) in which there is no Y axis, but only a X axis, it is to show how long it will take to escape. It is meant to show after one point, another would go straight after it, ideally I would like it to look like the attached The-egress-time-model-The-RSET-should-be-shorter-than-the-ASET-Reproduced-from-Proulx.png

Hello all,

I am fairly new to pivot tables and I am at my wits end to find out a solution to something

I have some data from a table which is working correctlly with the SUM function.

Sum.png

However, I want the SUMS for the Months with an AVERAGE of the months totals

If I change the the total to average it also changes the months to average, so I am getting an average of an average.

Average.png

I have read a few articles on this, but I really dont know what the solution is

Many thanks

]]>I am fairly new to pivot tables and I am at my wits end to find out a solution to something

I have some data from a table which is working correctlly with the SUM function.

Sum.png

However, I want the SUMS for the Months with an AVERAGE of the months totals

If I change the the total to average it also changes the months to average, so I am getting an average of an average.

Average.png

I have read a few articles on this, but I really dont know what the solution is

Many thanks

Hello,

I am in search of help for an advanced Pivot Table analysis. I've attached a mock excel document to show what I'm trying to achieve. In short...

I have a list of projects with their open year (i.e. 2017), close year (i.e. 2023), and funding amount (i.e. $20). I can create an easy pivot table to sum the number of projects opened each year with the total amount. However, where I am stuck is, I also want to create a pivot table of projects that shows the number and funding amount for ï¿½activeï¿½ projects for each year.

So, for example, I have 1 project that opened in 2018 and 3 in 2019. None of these 4 close until 2025 and beyond. For the annual year 2019 - it would only show 3, because only 3 opened in 2019. But for the active year 2019 - it would show 4, since I need to count the project in 2018 since it's still 'active' per it's 2018-2027 cycle.

The mock excel shows the formulas I'm using to achieve my intended results in a simplified way, but my actual dataset is massive and more complex so I would like to use a pivot table if possible (and eventually develop a dashboard); I just don't know how to tell it to calculate within these parameters.

Any suggestions welcomed! Thank you!

I am in search of help for an advanced Pivot Table analysis. I've attached a mock excel document to show what I'm trying to achieve. In short...

I have a list of projects with their open year (i.e. 2017), close year (i.e. 2023), and funding amount (i.e. $20). I can create an easy pivot table to sum the number of projects opened each year with the total amount. However, where I am stuck is, I also want to create a pivot table of projects that shows the number and funding amount for ï¿½activeï¿½ projects for each year.

So, for example, I have 1 project that opened in 2018 and 3 in 2019. None of these 4 close until 2025 and beyond. For the annual year 2019 - it would only show 3, because only 3 opened in 2019. But for the active year 2019 - it would show 4, since I need to count the project in 2018 since it's still 'active' per it's 2018-2027 cycle.

The mock excel shows the formulas I'm using to achieve my intended results in a simplified way, but my actual dataset is massive and more complex so I would like to use a pivot table if possible (and eventually develop a dashboard); I just don't know how to tell it to calculate within these parameters.

Any suggestions welcomed! Thank you!

I have a pivot (bar) chart linked to a pivot table. The row labels are "project status" as the pivot table is a management tracker tool and so has entries such as "new", "phase 1", "complete" etc. By default the pivot chart plots all the three columns of data from the pivot table:

1) Count of Project Status

2) Sum of Contract Value

3) Sum of Paid to Date

Although I need "count of project status" in the table, I don't want it on the same chart as (2) and (3). I want (2) and (3) together on one chart and (1) by itself on a separate pivot chart. However I can't seem to remove a data series from the pivot chart. Right-clicking the chart and going to "select data source" opens a dialog box showing all the data series but they are all greyed out and the usual "add/remove" functionality you get with a regular chart doesn't seem to work.

So my question is: how do I remove a specific data series from a pivot (bar) chart or am I stuck with having to plot ALL the data in the pivot table?

]]>1) Count of Project Status

2) Sum of Contract Value

3) Sum of Paid to Date

Although I need "count of project status" in the table, I don't want it on the same chart as (2) and (3). I want (2) and (3) together on one chart and (1) by itself on a separate pivot chart. However I can't seem to remove a data series from the pivot chart. Right-clicking the chart and going to "select data source" opens a dialog box showing all the data series but they are all greyed out and the usual "add/remove" functionality you get with a regular chart doesn't seem to work.

So my question is: how do I remove a specific data series from a pivot (bar) chart or am I stuck with having to plot ALL the data in the pivot table?

Hello guys, I'm pretty new here and I have been working on this project. I built a database of certain location coordinates and I've been looking for a way to represent those coordinates on a map on an excel sheet.

Is it all possible?

If so, How do I go about it?

Here below is an image of what I mean.

Any lead on this will be highly appreciated.

Screenshot 2023-12-01 110448.png

]]>Is it all possible?

If so, How do I go about it?

Here below is an image of what I mean.

Any lead on this will be highly appreciated.

Screenshot 2023-12-01 110448.png

I have worksheet with two columns: Specialty (text, formatted as General) and Date Started (formatted as Date)

Based on this date, I have a PivotTable that counts the amount of times each Specialty is listed.

I want to filter this list by Year.

I've added Date Started to Filters but I can only select individual dates, or manually select multiple dates.

Is it possible to automatically group the Filter by, for example, Year?

I am hoping you can assist without me requiring to upload the workbook.

Based on this date, I have a PivotTable that counts the amount of times each Specialty is listed.

I want to filter this list by Year.

I've added Date Started to Filters but I can only select individual dates, or manually select multiple dates.

Is it possible to automatically group the Filter by, for example, Year?

I am hoping you can assist without me requiring to upload the workbook.

Hello,

I would like a pie chart on the Dashboard sheet that shows the Category Groups spending amounts for the selected month.

I have the sheet Category Groups that shows the full list of categories that I manually entered into groups and the recommended spending percentages for each group.

I don't know how to go from here though.

I appreciate any help or suggestions.

Thank you

]]>I would like a pie chart on the Dashboard sheet that shows the Category Groups spending amounts for the selected month.

I have the sheet Category Groups that shows the full list of categories that I manually entered into groups and the recommended spending percentages for each group.

I don't know how to go from here though.

I appreciate any help or suggestions.

Thank you

I hope you understand this (!), but attached is a table (Values only) from a workbook in which I am summarizing game scores by date. The raw data is a collection of SUMIFs so it sums the data providing the date criteria is met (It pulls the data from a player-specific column. I want this data to be displayed as a line chart

This sounds easy enough, but Excel interprets this data as separate values instead of additive (?). For Player A, his first couple of scores are 52, 206, 13 & 139. I want the line chart to start at 52, then go to 258 (+206), then to 271 (+13), then 410 (+139). Instead, it goes up and down based on these values.

I assume there may be a setting or a helper column needed, but I don't wish to tinker with the actual table if I can help it.

This sounds easy enough, but Excel interprets this data as separate values instead of additive (?). For Player A, his first couple of scores are 52, 206, 13 & 139. I want the line chart to start at 52, then go to 258 (+206), then to 271 (+13), then 410 (+139). Instead, it goes up and down based on these values.

I assume there may be a setting or a helper column needed, but I don't wish to tinker with the actual table if I can help it.

I am trying to create a custom timeline that is equal to Date + 100 days. I have tried making a calculated field, but the dates in my table come out to xx/xx/1900, rather than their true values, which means excel isn't reading my input correctly. Additionally, it won't let me use this field as a timeline as I would like. I'm assuming it is a simple fix, but I'm not sure where to go from here.

]]>Hi, i wan my total (line with marker) to be show on top of the 100% stacked column.

I try to paste the $ value in my 100% stack column. The main thing is, my Line chart has to be ABOVE the 100% stacked column. If i change the chart type for my total to line, the line appear in the 100% stack column.

Hence i tried to change the $ value to % and add a 1 to it so that it will be above the 100% stack column.

However, the line do not show the up n down as clearly as it would if it is in $ value.

How should i do it?

I try to paste the $ value in my 100% stack column. The main thing is, my Line chart has to be ABOVE the 100% stacked column. If i change the chart type for my total to line, the line appear in the 100% stack column.

Hence i tried to change the $ value to % and add a 1 to it so that it will be above the 100% stack column.

However, the line do not show the up n down as clearly as it would if it is in $ value.

How should i do it?