I have created a query that generates a certain number of customers based on their sales volume. I would like to create a variable that would count the number of customers that are returned from this query. Can anyone give me some help?
can u give me u r Query structure?what r u having in rows and columns?do u have any structures?y i am asking is,i had similar kind of requirement and by using formulas,properties of kf and chars...we solved it...
My rows are just customers. My columns are '04 and '05 sales, plus the variance. I would like to have a fourth column that counts the number of customers (rows). I am filtering for certain customers based on the variance and I want to know how many I am getting.
How u r filtering customers based on variance? like...if varince is > or < particular value?
for example in u r filtering customers if variance is > 0.then create a new formula ( 'Variance' >= 0 ).and set calculate result as Summmation.It displays total no of customers whose variance is >0...and set Suppress result rows 'never' for Customer.
If you have a Counter key figure in your InfoProvider, you can use this in the query definition. In its properties Suppress the Single values and Calculate Results as Summation. This should work for simple scenarios...what else do you have in your query definition?
I do not have a counter field in my key figures. I am not an admin so I'm not sure if I can create this field. Assuming I can't, can you think of another option.
The query is very simple. Just a few other figures and dimensions.
You could try doing the same by creating a formula = 1. If you just have Customer in drilldown, it will work fine. If you add another char, then since there will be 1 for each row, it will not give you the number of customers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.