How to perform a COUNTD on a calculated fields made up of fields from blended sources (data blending Published source + excel), because you cant aggregate a field already aggregated. Is there any workaround like LOD calculations ?
Your issue is a little more complex than just trying to aggregate a field that is already aggregated - when you blend data files the blending takes place after the filters and dimensions have been placed on the worksheet (step 6 in the Order of operation) - the values from the secondary source are aggregated at the level of the link and the individual records are no longer available to the primary source - additionally Lods are calculated in step 4 of the order of operations before blending takes place so they are not a possible solution See it your way: Order of Operation (jimdehner2.blogspot.com)
if you post your workbook with the data source we may be able to offer a solution'
If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote.
Also please help use better track your reply by including a mention to the volunteer who provided the answer – mine is @[Jim Dehner]
Thank you.
Jim
