Calculating a total

%3CLINGO-SUB%20id%3D%22lingo-sub-1304779%22%20slang%3D%22en-US%22%3ECalculating%20a%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1304779%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20dataset%20whereby%20I%20add%20revenue%20numbers%20into%20a%20currency%20field%20for%20each%20order.%20We%20may%20have%20100%20orders%20in%20a%20month%20and%20each%20order%20will%20have%20a%20revenue%20figure%20in%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20now%20want%20to%20create%20a%20view%2Fweb%20part%2Fpage%20that%20summarises%20and%20displays%20this%20data%20on%20a%20monthly%20basis%20and%20adds%20a%20total%20(sum)%20or%20all%20the%20revenue%20for%20all%20opportunities.%20See%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22andrewmice_0-1586851734793.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F184173i15181DA9C78087CF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22andrewmice_0-1586851734793.png%22%20alt%3D%22andrewmice_0-1586851734793.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20guidance%20or%20could%20point%20me%20towards%20a%20tutorial%20of%20how%20to%20do%20this%3F%3C%2FP%3E%3CP%3EThank%20you!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndrew%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1304779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1351701%22%20slang%3D%22en-US%22%3ERe%3A%20Calculating%20a%20total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1351701%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F612329%22%20target%3D%22_blank%22%3E%40andrewmice%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ECan%20you%20please%20attach%20another%20screenshot%20of%20the%20place%20that%20you%20entering%20the%20data%3F%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20understand%20your%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all,

 

I have a dataset whereby I add revenue numbers into a currency field for each order. We may have 100 orders in a month and each order will have a revenue figure in it. 

 

I now want to create a view/web part/page that summarises and displays this data on a monthly basis and adds a total (sum) or all the revenue for all opportunities. See below:

 

andrewmice_0-1586851734793.png

 

Does anyone have any guidance or could point me towards a tutorial of how to do this?

Thank you!!!

 

Andrew

 

1 Reply
Highlighted

@andrewmice 

Hello,

Can you please attach another screenshot of the place that you entering the data?

I am trying to understand your list.