% Column adding up and not showing the line %

[Yollies]

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 lineThe GP5 column is adding up instead of showing the real % . Note that i have a filter on month and i have selected 5 month

[Yollies]

How do i share the file?

[themistoklis]

@Yollies

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

[Yollies]

What email address do i add in wetransfer?

thanks

[themistoklis]

@Yollies

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

[Yollies]

https://we.tl/t-v6K3Nc7eXG

[Yollies]

https://wetransfer.com/downloads/048b16d73ab0998241924126f198d59720181207065913/eed2c4fc2e2d5837dc94...

[themistoklis · Accepted solution]

@Yollies

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

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

[themistoklis]

@Yollies

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

Mask any sensitive data