Sales Target

[tmears]

Hi

This maybe a real simple question, but how is the best way to get a static target figure, into my Data.  I would like to put a £100,000 monthly sales target, but am drawing a blank on the best way to do this

Many thnaks

Tim

[Sean]

@tmears

If you don't want to hardcode this number in your Measures

You can always create a Create a COLUMN

Sales Target = 100000

Good Luck!

[Greg_Deckler · Accepted solution]

I tend to use an Enter Data query and just hard code my goals and such. You can also just create a custom column or measure like so:

Measure = 100000

[tmears]

Great thanks Guys