Hi All,
I would like to ask for assistance regarding on my concern.
I created a Standard Measure source from a field, this measure is setup to a "DistinctCount" type. Measure shows values when report is generated but i have noticed that the Sum total of values is not equal on what the excel is calculating.
Any insights is very helpful right now.
Thank you.
Hello Robert -
What is the function or formula in the total cell on line 28 (value: 20,038) in your report?
Hi Harry,
It does not have a formula but a grand total function of excel where it calculates the total number of "Docket Count".
From the two screen shots, it appears that (for whatever reason) the Pivot table is consistently only totaling the last two values (in this case Others and Take-aways). You may want to send a copy of your report to Jet Global Tech Support to see what might be going on.
Yes, i agree on that Harry. The weird part is that when i counter checked the data integrity of the "delivery" subgroup. It warrants what value is displayed.
On the other hand, have you encounter this issue before? or is there any article related to this as this particular measure is vital for all reports that i am designing. Not sure if this will be fixed by a MDX expression which I am not so familiar with. Any idea?
Thanks, already raised ticket for this.
Hello Robert,
have you been able to fix this issue? How?
Thanks and best regards,
Johannes Herlitzius
Hi Johannes,
The issue is actually because of the source field that I am using which is not unique on all setup like company, store and POS terminal. Thus the Transaction Number will definitely not be counted correctly by applying a distinct count type. Having said that, I have to change my field source to show the docket count and the very good candidate is using the "receipt number". This data is generated uniquely across all setup (Company, Store and POS terminal). As a result, you'll be getting the correct docket count as well as its total count.