Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
i have a problem that I cant solve in a good way.
i will simplify the problem so everyone can undestand.
I have 2 tables.
One is a table with transactions of Custormers something like.
IN dimension:
NIF-code-name-order-products
IN expresions:
Sales
Total Sales
Gross Sales....
and have other Table (linked by NIF)
NIF - MINIMUN-MAXIMUN-DISCOUNT
In this table we have a discount per client base on minimun and maximun Sales.
Example:
A20022002 10.000 20.000 1%
A20022002 20.000 30.000 2%
A20022002 30.000 40.000 3%
A20022002 40.000 990.000 4%
so the want that i need to do is, in the master table I want to put the discount. based on total sales. Any help will be very appreciated.