cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yollies Frequent Visitor
Frequent Visitor

% Column adding up and not showing the line %

Hi.  I have a straight set of data. In my query i have a calculated column Gross Profit and a calculated column for GP%. Then i bring the table in and have option to select say 2 months then it adds th % and not keep it per linePic 1.PNGPic2.PNGThe GP5 column is adding up instead of showing the real % . Note that i have a filter on month and i have selected 5 month

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
themistoklis New Contributor
New Contributor

Re: % Column adding up and not showing the line %

@Yollies

 

Create a new Measure and NOT a Column and add this formula:

 

Measure = divide(SUM(ACT[GPROFIT]),SUM(ACT[NSV]),0)
8 REPLIES 8
themistoklis New Contributor
New Contributor

Re: % Column adding up and not showing the line %

@Yollies

 

What is the formula that you are using? Any chance to share the workbook with us?

Mask any sensitive data

Yollies Frequent Visitor
Frequent Visitor

Re: % Column adding up and not showing the line %

How do i share the file?

 

themistoklis New Contributor
New Contributor

Re: % Column adding up and not showing the line %

@Yollies

 

Share it through a dropbox link or upload it to a website and share it with us (e.g. wetransfer.com)

Yollies Frequent Visitor
Frequent Visitor

Re: % Column adding up and not showing the line %

What email address do i add in wetransfer?

 

thanks

themistoklis New Contributor
New Contributor

Re: % Column adding up and not showing the line %

@Yollies

 

Yours so as to get the link and then share the link with us

Yollies Frequent Visitor
Frequent Visitor

Re: % Column adding up and not showing the line %

Yollies Frequent Visitor
Frequent Visitor

Re: % Column adding up and not showing the line %

themistoklis New Contributor
New Contributor

Re: % Column adding up and not showing the line %

@Yollies

 

Create a new Measure and NOT a Column and add this formula:

 

Measure = divide(SUM(ACT[GPROFIT]),SUM(ACT[NSV]),0)