Prev: Filtering for "Not Something"
Next: Time difference between multiple times and dates
From: matthijs on 30 Jun 2008 06:20
Hello,

I have a query that I want to show in the pivot chart view. The legend shows
the field with "Sum of" in front. Even when I use an alias the "Sum of"
stays. Can I get this removed in some other way? I know the "Sum of" is
required to create a pivot, but is there a trick of not showing it in the
legend?

SELECT [overview test].date_date, [overview test].[skids company1],
[overview test].[skids company2], [overview test].[skids company4], [overview
test].[skids company4], [overview test].[skids company5], [overview
test].[skids company6]
FROM [overview test];

Regards,

Matthijs
 | 
Pages: 1
Prev: Filtering for "Not Something"
Next: Time difference between multiple times and dates