Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hello all Is there a way we can ge

Status
Not open for further replies.
neil2grow

neil2grow

IS-IT--Management
Nov 19, 2003
30
0
0
US
Hello all
Is there a way we can generate mtd amounts from ytd amounts,i know that we have to subtract from previous amounts ytd,but how to do it.any insight
Thanks in advance
Neil
 
Sort by date Sort by votes
Select ytd and previous ytd column and then go the calculate --> subtract.
 
Upvote 0 Downvote
saikat
I dont follow it.can you please explain
Thanks
Neil
 
Upvote 0 Downvote
Are you using a powerplay report. If yes

1.open the report
2.Toggle the dimension viewer (Under Explore menu)
3. From the dimension viewer explore the date dimension you have
4. First check whether you have a category named MTD or not?


 
Upvote 0 Downvote
saikat
No i am not using a powerplay report,i am using a impromptu report,any suggestions on it
Thanks
Neil
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

NicolaTesla1
  • Locked
  • Question
Hi, Anyone has ever had issues w
Replies
0
Views
50
NicolaTesla1
NicolaTesla1
NileshDhande
  • Locked
  • Question
Can I use web api as data source to cognos?
Replies
0
Views
76
NileshDhande
NileshDhande
tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
69
tushargaurav
tushargaurav
BNCianciolo
  • Locked
  • Question
Cognos Script Export with "<All=true>" method
Replies
0
Views
38
BNCianciolo
BNCianciolo
ihcc2uni
  • Locked
  • Question
Cognos 10 - Export all reports and details
Replies
0
Views
34
ihcc2uni
ihcc2uni

Part and Inventory Search

Sponsor

Back
Top