Forum

Hi Mattias, It doesn't sound like you want a weighted average, just a regular average either by day, month or year. Have you tried using AVERAGEX? ...

Hi David, Thanks for sharing the video. I've not seen that use for commodity futures before. Very interesting. I had sporadic success with it e.g. ...

Hi David, Not sure why you're using the @ sign before the ticker. You need to prefix the stock ticker with the exchange 'market identifier code' as...

Hi and welcome to our forum! It's difficult to picture what you mean without seeing an example file. If you want the spacing of lines 3-5 to remain...

Hi Mortimer, Welcome to the forum! The file you're seeing is correct. It's the same file shown in the video for lesson 3.10. Mynda

Hi Erik, Still very difficult to create an image in my head from your description as to what the issue is. Usually when dealing with sensitive data...

Hi Steve, From what I know about the current priorities for building new chart functionality, I'd say the chances of Microsoft building a new Pivot...

Interesting...when you display both vertical axes the scale for the two series changes so that the 740 column is higher than the 795 column. I turned ...

Hi Eric, Maybe what you need to use is Power Pivot to create relationships between your tables using the Case# field. However, like Phil mentioned,...

Sneaky trick, Sunny 😉 The only problem I see is that the primary and secondary vertical axis aren't to the same scale for Riviera school and Fran...

Hi Steve, Thanks for sharing your file and example chart. Unfortunately, Pivot Charts are not flexible enough to enable you to build this chart. If...

Hi Jennifer, Why don't you just put the gender in the filter field and filter for Female? Mynda

Hi Jessica, There's no workaround that I'm aware of. Perhaps you can create a field that you can sort numerically e.g. mm-yy or if you'll have mult...

Hi Jingjing, It sounds like you're watching the old version of the course which was recorded before we had the new histogram charts available. You ...

Hi Bax, The quickest file type to import is a .csv or .txt file. Seeing that you only have one sheet in each file, why not change the file types to...