Forum Discussion
calculated field
Need help on calc field per company as buy and sell are 2 diff rows. They need to be net off to get the profit from the transaction done that day... hope somewat clear
Hi Anonymous ,
Can you please explain a little bit better what is the expected result?
Hi Anonymous ,
If you use a matrix visualization and place the Trans column in the columns you get the expected result:
This depends on how you want to setup everything but then making some measures you can have the results has you need.
let me try again - am trying to get a summary say as pivot in excel of buy and sell trnsctions a day over few days. sheet 'b s indiv' is the base data
Thnx in advance
Hi Anonymous ,
If you use a matrix visualization and place the Trans column in the columns you get the expected result:
This depends on how you want to setup everything but then making some measures you can have the results has you need.