Skip to Content
0
Dec 25, 2017 at 11:54 AM

Restricting key figures in BEx

190 Views Last edit Dec 25, 2017 at 11:58 AM 3 rev

Hi,

I've a reporting requirement.

The user wants to display single line item for each invoice document.

tax-1.jpg

So, I removed the Bill document number, but the problem I'm facing is the tax amount is getting summed which shouldn't happen as per requirement.

tax-3.jpg

I want to avoid summing the tax amount and display it as a single amount.The tax amount value is singular for invoice.

Can this be achieved in BEx?

This is the output I want to display

tax-2.jpg

Kindly, please let me know.

Attachments

tax-1.jpg (26.7 kB)
tax-2.jpg (19.1 kB)
tax-3.jpg (20.8 kB)