happy 1001
asked on
Excel - doing Sum inside Data Model
Hi Experts
I am doing some experiments in Excel Power Pivot Data Model and I am a total newbie in it. So I am not being able to figure out a method by which I can ADD Multiple Rows to get the Total or Sum Values for them.
I want to add the values for each row which have same value in xdate column, symbol column and putcall column.
I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64
I have attached the Excel File having the data.
Doing-Total-in-Data-Model.xlsx
I am doing some experiments in Excel Power Pivot Data Model and I am a total newbie in it. So I am not being able to figure out a method by which I can ADD Multiple Rows to get the Total or Sum Values for them.
I want to add the values for each row which have same value in xdate column, symbol column and putcall column.
I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64
I have attached the Excel File having the data.
Doing-Total-in-Data-Model.xlsx
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you xtermie
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
But I need to do this inside the Power Pivot Data Model and not in the excel sheet table.
And secondly, there should be just One Single Row for each Date per symbol for putcall column having values of C and P.
Thanks